Competition chart with residual data

Excel 2013
For some presentation of the competition will be more informative to see points that missed to achieve the Goal. This tip is about how to create simple competition chart with residual data.
The Competition Chart Excel 2016

To create the chart like this one, do the following:

   1.   Add additional data to you chart to see the residual data (in this example, cells C17:D17):

   2.   Select all necessary data - in this example, C4:D4, C15:D15, C17:D17:

Data Competition Chart Excel 2016

   3.   On the Insert tab, in the Charts group, choose the Column button:

Bar Charts in Excel 2016

Choose 100% Stacked Column: 100% Stacked Column in Excel 2016

   4.   Right-click on second series and in the popup menu select Add Data Label and again Add Data Label:

Add Data Label in Excel 2016

Make any other adjustments to get the look you desire. See more:

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.