Pie chart orders by country

New Contributor

That must be really simple, but I'm still failing to understand how to do so.

I have a column with orders values and another one with countries where orders originate from. I want a pie chart showing the orders value percentage for each country (grouped by country).


Help please!

2 Replies


To group by country you may create PivotTable and build the chart based on it. If you have more than 3 countries bar chart will be better compare to pie chart.

Thank you!