A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend.

An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I show below.

DOWNLOAD WORKBOOK

Line Chart

 

 Helpful Resource:

project-management-bundle-excel-ad-2

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Win/Loss Sparklines When you have  a large data set with positive and negative numbers, a great way to visualize the trend is to add a Win/Loss Sparkline next to your data.That way you or the reader can easily spot the trends and patterns.To enter a Win/Loss Sparkline in Excel you firstly ne...
Sparklines: Line Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell.You can style them in different colors and add a marker for the High and Low points of your data.  As your data changes so do the Sparklines, which gives them that much more pow...
Benchmark Chart in Excel 2013 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months.There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts. ...
Thermometer Excel Chart Thermometer Charts are one of the many Charts you can create in Excel.  It does not really exist in Excel, however we can get creative and create our own.A Thermometer Chart gives you a good view of the percentage of progress made on your project, budget etc.We are going ...