Creating a simple competition chart

Excel 2016 2013
This tip shows how to create a simple competition chart using a bar chart.
The Competition Chart Excel 365

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

   1.   Select all necessary data - in this example, C2:D2, C13:D13:

Data Competition Chart Excel 365

   2.   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 Clustered Bar:

Clustered Bar Chart in Excel 365

   3.   Right-click on the chart and in the popup menu, select Add Data Labels and again Add Data Labels:

Add Data Label in Excel 365

   4.   Select one of the data labels:

Change Data Label in Excel 365

   5.   Right-click on the selected data label and select Format Data Label... in the popup menu:

Format Data Label in popup menu Excel 365

   6.   On the Format Data Label pane, on the Fill & Line tab, in the Fill section:

  • Choose Picture or texture fill,
  • Click on the Insert... button:
    Fill Data Label in Excel 365
  • In the Insert Pictures dialog box, choose the picture location, select the picture file, and then click Open or Insert:
Insert pictures in Excel 365

   7.   Make changes for the second data label (repeat steps 4 - 6 for it).

Make any other adjustments to get the look you desire, see also Creating a chart with dynamic labels.

See also this tip in French: Créer un graphique de compétition simple.

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