Creating a simple competition chart

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

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

    1.    Select all necessary data - in this example, C4:D4, C17:D17:

Data Competition Chart Excel 2016

    2.    On the Insert tab, in the Charts group, choose the Bar button:

Bar Charts in Excel 2016

Choose Clustered Bar:

Clustered Bar Charts in Excel 2016

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

Add Data Label in Excel 2016

    4.    Select one of the data labels:

Change Data Label in Excel 2016

    5.    In the Format Data Label task pane, on the Fill & Line tab, in the Fill group, check Picture or texture fill and then click on the File... button (if you have the picture already), Clipboard or on Online... (if you would like to upload picture from Internet):

Fill Data Label in Excel 2016

    6.    Make changes for the second data label (repeat steps 4 and 5 for it).

Many thanks for funny icons.

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

Ask a Question

We use your email only for the communication between you and our team.

Your email Please enter your email Your email

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

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.