Create a bar/pie of pie chart for an excel report

This graph is very useful when I need to show side by side the total product and the sub-total of a particular product. It allows me to emphasize one aspect of my report so telling to my customer to focus particularly in this section.

I remember that when I did it the first time, it was not easy to understand, even looking into internet, I couldn’t find the right explanation and at the end, by guessing and testing, I found out the how to.

pie of pie chart excel pie of pie chart excel

I will explain the pie of pie graph because the bar of pie chart works the same way. Imagine that I have those data:

pie of pie chart excel

And I want to show on the left side, the countries and on the right side, the French cities so if I am selecting all data of the column A and B, I got the chart above.

As you can see, the “France” data is showing twice and it is something that I don’t want. By selecting the same data but without the row 4 (the France one), I got almost the correct chart but at least, France is not duplicate anymore.

pie of pie chart excel

To have all the cities on the right side, I have to right click on the pie and select the “format data series” option:

pie of pie chart excel

I will get this panel and on the “values in second plot” field, I will put “4”:

pie of pie chart excel pie of pie chart excel

Automatically, the chart will be updated and now, I have the correct graph:

pie of pie chart excel

As you can see, it is not complicated but may be I am not smart enough to understand quickly how to create this kind of charts :-)

Interesting Topics