charts

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts

Charts

resolvedResolved · Medium Priority · Version 2007

Jean has attended:
Excel Introduction course
Excel Intermediate course

Charts

How do you determine which charts are right for the data you're trying to illustrate?

RE: Charts

Hi Jean, thanks for your query. It depends a lot on the data you're using and your audiance. The link below gives you a walkthrough of basic chart protocol and when to use them:

http://www.spreadsheet123.com/charttypes.html

Hope this helps,

Anthony

Sun 13 Feb 2011: Automatically marked as resolved.


 

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

View all Excel hints and tips


Server loaded in 0.09 secs.