Pinterest Pixel

Benchmark Chart in Excel 2013

Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Benchmark Chart in Excel 2013 | MyExcelOnline Benchmark Chart in Excel 2013 | MyExcelOnline

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.


Benchmark Chart in Excel 2013 | MyExcelOnline

Download excel workbookBenchmark-Chart.xlsx

STEP 1: Enter your data into three columns, the month, the actual sales and the benchmark sales

STEP 2: Click inside your data and go to the ribbon and choose Insert > 2-D Clustered Column

STEP 3: Select the Benchmark series chart and Right Click and choose the Change Series Chart Type

Benchmark Chart in Excel 2013

STEP 4: This will automatically take you to the Combo chart box and you need to select the drop down for the Benchmark and select Line with Markers

Benchmark Chart in Excel 2013

STEP 5: Click on the line chart and press CTRL+1.  This will open up the Format Chart dialogue box

STEP 6: Select the Line option and choose No Line

See also  Create a Treemap Chart With Excel 2016

Benchmark Chart in Excel 2013

STEP 7: Select the Marker Options and choose Built In, select the horizontal line type and increase the Size to 10.  You can also format the color of the line.

Benchmark Chart in Excel 2013

 

MOTH 468x90.update.your.skills.animated.chart.learn.online.2

If you like this Excel tip, please share it
Benchmark Chart in Excel 2013 | MyExcelOnline Benchmark Chart in Excel 2013 | 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...