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