Competition chart with residual data

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

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):
Data Competition Chart Excel 365

   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:

Insert Column or Bar Chart in Excel 365

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

100% Stacked Bar Chart in Excel 365

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

Add Data Label in Excel 365

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

See also this tip in French: Créer un graphique de concurrence avec des données résiduelles.

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

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more