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:

• How to create dependent on a volume chart title.
• Creating a chart with dynamic labels.