excel consultants - creating graphs
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Creating graphs

excel consultants - Creating graphs

resolvedResolved · Low Priority · Version Standard

replyReply Tue 21 Aug 2007, 09:51Delegate Amina said...

Amina has attended:
Excel Intermediate course

Creating graphs

How would you create a graph

For upcoming training course dates see: Pricing & availability

replyReply Wed 22 Aug 2007, 05:21Trainer Tracy said...

RE: Creating graphs

Hi Amina,

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.

Tracy

 

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard