Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel course london - How to make graphs??

	98.1 % recommend us
	More live stats...

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

Training information:

advanced excel course london - How to make graphs??

Resolved · Low Priority · Version Standard

Reply Tue 21 Aug 2007, 09:51Delegate James said...

James has attended:
Excel Intermediate course

How to make graphs??

I need to know how to create graphs using data in excel any tips/pointers??

For upcoming training course dates see: Pricing & availability

Reply Wed 22 Aug 2007, 05:22 Edited on Wed 22 Aug 2007, 05:24Trainer Tracy said...

RE: How to make graphs??

Hi James,

Thanks for the question.

You can create a chart by putting your active cursor in the data you wish to convert to a graph and using the chart wizard. This is a button on your toolbar which looks like a miniture chart. Here you have a four stage procedure where at each stage you can change the settings of your chart until you are happy with it and you press "finish". Alternatively pressing F11 will also create a standard graph.

Take a look at our Hints and Tips Page on the website for hints on all microsoft applications

Tracy

Excel articles

· Customize Your Gridlines And Borders In Excel 2007
· What's In A Number? Make Figures Mean More Via Excel
· Create A Basic Timeline In Excel
· Charting Your Success With Excel 2007
· Where Are The Form Controls In Different Versions Of Excel

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips