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.

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