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

Combine Column & Line Charts in Excel Some times you may come across a situation where you want to show 2 variables in one Excel chart.For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables.Well you c...
Area Chart: Highlight Chart Sections When you are showing 12 month sales results using a Line Chart and want to highlight certain values within the chart to make them stand out (like Q2 & Q3 results), then an Area Chart will be needed.To do this there are a few steps to follow:1. Enter the Line Chart for...
Save A Chart Template Saving a Chart template in Excel is an efficient way to reuse your favourite or your company´s standard chart template.So whenever you have new data and want to create a chart with your (company´s) standard formatting, all you need is a couple of clicks and you will have it s...
Pie Charts in Excel Pie Charts are used widely in the Microsoft Excel community but for the wrong analysis.Even though pies are delicious!, a Pie Chart should only be used to show several parts that make up a whole, for example, a product cost breakdown, margin breakdown or the market share of c...