advanced excel course london - how make graphs

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

advanced excel course london - How to make graphs??

resolvedResolved · Low Priority · Version Standard

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??

Edited on Wed 22 Aug 2007, 05:24

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 tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips


Server loaded in 0.09 secs.