Pie Charts with text-based values?

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I have a table that looks similar to this:

DATE NAME
Feb 14 Joe
Feb 2 Harry
Jan 29 Harry
Jan 24 Joe
Jan 22 Harry
Jan 15 Bill

Is there any way I can make a pie chart that shows 30%
Joe, %50 Harry and %20 Bill?
If so, how?
Any help would be much appreciated!
 
Amy -

Select the NAME column and make a pivot table. Put the NAME field in the
Row area of the layout, and NAME in the Data area (it will turn to Count
of NAME). You get a pivot table that looks like this:

Count of NAME
NAME Total
Bill 1
Harry 3
Joe 2
Grand Total 6

Make a pie chart of this part of it:

Bill 1
Harry 3
Joe 2

and display data labels using the Show Percentages option. By the way,
it's 33% Joe and 17% Bill.

- Jon
 
Back
Top