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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

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 ...
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. ...
100% Stacked Bar Chart A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total.So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year.DOWNL...
Organizational Charts in Excel Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt.To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational...