Creating a simple competition chart

Excel 365
This tip shows how to create a simple competition chart using a 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, click the Bar button:

Bar Charts in Excel 2016

Choose the Clustered Bar Clustered Bar Charts in Excel 2016 chart.

   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 2016

   4.   Select one of the data labels:

Change Data Label in Excel 2016

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

Format Data Label in popup menu Excel 2016

   6.   On the Format Data Label 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 Online... (if you would like to upload picture from Internet):

Fill Data Label in Excel 2016

   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.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.