advanced.excel - chart
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 » advanced.excel - Chart

advanced.excel - Chart

resolvedResolved · Low Priority · Version Standard

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

Holly has attended:
Excel Intermediate course

Chart

How do you enter a chart

For upcoming training course dates see: Pricing & availability

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

RE: Chart

Hi Holly,

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:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

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