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.
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.
Right click on the “Red bar” (Cost bar) and select “Format Data Series”. The below screen will appear. Mark the “secondary axis” option.
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”.
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.
Right click on the Sales Bar and select format data series. Enter “23%” in the “Gap width” option
Add the data labels to the charts if you prefer it.