Creating a funny competition chart
The trick of this chart is to show different colors for different parts. If you create a simple competition chart, you will see the same colors for any data:
To create the chart like this one, do the following:
1. Add additional data:
- Cells for every colors - in this example cells C17:D20.
- Cells for very small data for labels (in this example cells C16:D16)
2. Select cells C4:D4, C16:D20.
3. On the Insert tab, in the Charts group, choose the Bar button:
Choose Stacked Column:
4. If it is necessary, change data in the Select Data Source dialog box:
- Right-click in the chart area. In the popup menu select Select Data...:
- In the Select Data Source dialog box:
- Click the Switch Row/Column button (to see 5 series).
- Move series for very small data to the end of list. To do that, select the series and then click to the Move Down or Move Up buttons (in this example, series 1 should be in the bottom of the list of series).
5. Open the Format Data Series, for example, by right-clicking in the data series and choosing Format Data Series... in the popup menu:
6. In the Format Data Series task pane, on the Fill & Line tab for every data series choose the fill you prefer (in this example was chose Gradient fill, for very small data was chose No fill).
7. Select the very small data series and for it, in the popup menu select Add Data Label and again Add Data Label:
8. Select one of labels and then open the Format Data Label task pane (for example, by selecting in the popup menu Format Data Labels...).
9. 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).
10. Make changes for the second data label (repeat steps 8 and 9 for it).
Many thanks megaicons.net for funny icons.
Make any other adjustments to get the look you desire, see also Creating a chart with dynamic labels.
Permission is granted for article quotations from OfficeToolTips, provided the direct link to the source articlehttp://www.officetooltips.com/excel 2013/tips/creating a funny competition chart.html