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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Logarithmic Scale In An Excel Chart When you have a large numerical range of data and you want to plot a graph, you will most probable end up with a skewed looking chart like the one below: You can use the logarithmic scale (log scale) in the Format Axis dialogue box to scale your chart by a base of 10. W...
Excel Cycle Charts Cycle Charts in Excel are easy to create using the Smart Art feature. There are several cycle process charts to choose from, some have arrows, like the Basic Cycle, and others show the relationship to a central idea, like the Radial Cycle. Here is how you insert a Radial Cy...
Create a Box and Whisker Chart With Excel 2016 Box and Whisker Charts are one of the many new Charts available only in Excel 2016 and were originally invented by John Tukey in 1977. They show you the distribution of a data set, showing the median, quartiles, range and outliers. The X in the box represents the Mean. ...
Benchmark Chart in Excel 2010 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. I will show you how to do this using Using Excel 2010. DOWNLOAD EXCEL WORKBOOK STEP 1: Enter your data into three ...