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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
charts

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

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

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.11 secs.