Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-xp-training - Graphs

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel-xp-training - Graphs

Resolved · Low Priority · Version Standard

Reply Thu 10 Jan 2008, 13:24Delegate Chris said...

Chris has attended:
Excel Intermediate course

Graphs

How to make a graph?

For upcoming training course dates see: Pricing & availability

Reply Tue 15 Jan 2008, 14:00Trainer Katie said...

RE: Graphs

Hi Chris,

Thanks for your question.

Two ways to create a graph:
A. If you are not too fuss about location / graph type:
1 - Select data table (i.e. labels & numbers) on worksheet
2 - Press F11 (by default, it creates a 2D column chart on a new sheet)

B. Use Chart Wizards:
1 - Select data table (i.e. labels & numbers) on worksheet
2 - Click on INSERT menu > Chart
3 - Go through the 4 steps to select Chart Type, set up labes / axis / gridlines / legend and location.
4 - press ok

Hope this helps.

Regards,

Katie

Reply Tue 15 Jan 2008, 14:07Delegate Chris said...

RE: Graphs

Tks for this Katie!
Chris

Excel articles

· The Secret Formula To Creating Correct Calculations In Excel
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· How Excel Can Boost Even The Smallest Business
· Why Should I Learn Visual Basic in Excel?
· How To Get The Best Out Of Excel With The Internet

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips