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 the 12 months of sales;

2. Enter the values you want to highlight on a separate column next to the sales;

3. Click on the Line Chart and drag the blue line that is in the sales column to include the new column (in point 2);

4. Click on the chart and go to Chart Tools > Layout > Select Series 2;

5. Go to Chart Tools > Design > Change Chart Type > Area Chart;

6. Right click in the Area Chart and format it to your liking with a light color.

DOWNLOAD WORKBOOK

Area Chart

Helpful Resource:

MOTH 468x90.update.your.skills.animated.chart.learn.online.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

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. ...
Excel Sparklines with Excel Tables Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can! To create an Excel Table you need to highlight your data and press CTRL+T See Tutorial Here Once you have your Excel Table you can add your Excel Sparklines inside one Column and us...
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 ...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story. You can adjust the WIDTH of the line to make it as thin or thick as you like. You can make your line chart have a COMPOUND or DASH effect. You can also add...