Creating a simple competition chart

Excel 2016
Competition is an integral part of the development of any company and community. From childhood, we compete for our favorite toys among peers, for leadership in games, and so on. Healthy competition helps to achieve many goals: from quickly solving problems to choosing the most appropriate strategy.

Visualizing a competition is a quite simple, but pretty creative process:

The Competition Chart Excel 365

The easiest way to visualize the competition process is to create clustered bar charts, in which a comparison is made between two or more objects, phenomena, or groups of data. The graphics are accompanied by a textual representation of the progress in percentage or quantitative format.

To create a chart like the one above, 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 Bar or Column 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 data series, then select Add Data Labels -> Add Data Labels in the popup menu:

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 the Picture or texture fill option,
  • 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 to the second data label (repeat steps 4 - 6).

Note: Instead of adding data labels for points scored or results achieved, the graph can show the remaining scores to reach the Goal.

Make any other adjustments to get the desired look; see also how to create 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.