Overlapping Bar Chart

by on May 2, 2017

Overlapping Bar Chart

Overlapping Bar chart is a chart in which Bars are overlapped each other (Image provided below). Our objective is to build the chart as provided below.

Overlapping Bar Chart

Step 1:

Select the data, and simply insert the simple bar chart from insert tab. Select the colors (Light blue for sales, Red for cost and Dark blue for the Profit). You can pick your colors as well.

Overlapping Bar Chart

Step 2

Right click on the “Red bar” (Cost bar) and select “Format Data Series”. The below screen will appear. Mark the “secondary axis” option.

Overlapping Bar Chart

Overlapping Bar Chart

Step 3

Repeat the step 2 for Profit Bar. Your updated chart will be look like the one below. Now right click on the Secondary Axis and click “Format Axis”.

Overlapping Bar Chart

Overlapping Bar Chart

Step 4

Enter “25000” in the Maximum Box and press the Enter key. We enter 25000 so that Primary and secondary Axis have the same upper limit.

Overlapping Bar Chart

Overlapping Bar Chart

Step 5

Right click on the Sales Bar and select format data series. Enter “23%” in the “Gap width” option

Overlapping Bar Chart

Step 6

Add the data labels to the charts if you prefer it.

Overlapping Bar Chart

Please follow and like us:
0

Leave a Reply

Your email address will not be published. Required fields are marked *