Competition chart with residual data
![The Competition Chart Excel 2016 The Competition Chart Excel 2016](/images/tips/345_2016/1.png)
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 C17:D17).
2. Select all necessary data - in this example, C4:D4, C15:D15, C17:D17:
![Data Competition Chart Excel 2016 Data Competition Chart Excel 2016](/images/tips/345_2016/2.png)
3. On the Insert tab, in the Charts group, choose the Column button:
![Bar Charts in Excel 2016 Bar Charts in Excel 2016](/images/tips/excel_button2016/column_chart.png)
Choose the 100% Stacked Column
chart.
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 2016 Add Data Label in Excel 2016](/images/tips/excel_button2016/add_data_labels.png)
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.