charts

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Charts

resolvedResolved · Low Priority · Version 2003

David has attended:
Excel Introduction course

Charts

Line graphs

RE: Charts

Dear David

Thank you for attending Excel Introduction!! I hope you enjoyed the course and benefited from it.


I would request you to clarify your query. Would you like to know how to create a Line chart or would you like to know the theoretical knowledge of when should a Line chart be used.

Theoretically speaking Line chart is best used when you are trying to show a trend along a time series!! E.g. Year by year analysis of house market, day by day increase in the Petrol prices, etc.

You CAN create a line chart for two series without a time trend but it doesn't show the perfect picture that you may wish to see.

To create a Line chart is very similar to creating a column chart the only difference is that you choose the Line chart in the first step of the chart wizard. If you are not sure how to create a chart at all please let me know and I should be able to provide you a step by step instructions!!


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Fri 26 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips


Server loaded in 0.08 secs.