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

advanced excel course london - how make graphs

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

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

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.