Thursday, August 9, 2012

Excel: Create Pie chart from single column


  1. Add new column (e.g. Count) and fill it with 1
    enter image description here
  2. 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)
    enter image description here
  3. On the PivotTable Filed List drag Country to Row Labels and Count to Values
    enter image description here
  4. Now select the pivot table data and create your pie chart as usual.
    enter image description here
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.
Subscribe to RSS Feed Follow me on Twitter!