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.
