Creating a simple competition chart

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

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

   1.   Select all necessary data - in this example, C4:D4, C15:D15:

Data Competition Chart Excel 2013

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

Bar Charts in Excel 2013

Choose Clustered Bar.

   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 2013

   4.   Select one of the data labels:

Change Data Label in Excel 2013

   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):

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

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

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

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