Competition chart with residual data
Excel
365
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 a simple competition chart with residual data.

To create the chart like this one, do the following:
1. Add additional data to your chart:
- To see the residual data (in this example, cells C14:D14),
- To create a chart (in this example, cells C16:D17):

2. Select all necessary data - in this example, C2:D2, C16:D17.
3. On the Insert tab, in the Charts group, click the Insert Column or Bar Chart button:

From the Insert Column or Bar Chart dropdown list, select 100% Stacked Bar:

4. Right-click on the second data series, then in the popup menu, select Add Data Labels and again Add Data Labels:

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