Create a pie chart from distinct values in one column by grouping data in Excel

[ForumBot]

Create a pie chart from distinct values in one column by grouping data in Excel

[ForumBot]

This is how I do it:

-
Add a column and fill it with 1 (name it Count for example)

-
Select your data (both columns) and create a Pivot Table: On the
*Insert* tab click on the *PivotTable* | *Pivot Table* (you can
create it on the same worksheet or on a new sheet)

-
On the PivotTable Field List drag *Country* to *Row Labels* and
*Count* to *Values* if Excel doesn't automatically

-
Now select the pivot table data and create your pie chart as
usual.

P.S. I use the pivot table for I update the data on a regular basis, then I just replace the "*Country*" data and refresh the pivot table.