Pinterest Pixel

Area Chart: Highlight Chart Sections

When you are showing 12 month sales results using a Line Chart and want to highlight certain... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Area Chart: Highlight Chart Sections | MyExcelOnline Area Chart: Highlight Chart Sections | MyExcelOnline

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.

Want to know how to create an Area Chart?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍

Area Chart: Highlight Chart Sections | MyExcelOnline

 

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);

See also  Clustered Bar Chart: Year to Date Sales

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 workbookArea-Chart.xlsx

 

 

If you like this Excel tip, please share it
Area Chart: Highlight Chart Sections | MyExcelOnline Area Chart: Highlight Chart Sections | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...