I am using a pivot table to summarize hours worked. In the Pivot Table
Wizard Layout, the first field in 'Page' determines which month to report on.
The second field in 'Page' is the employee. The 'Row' displays the type of
work done and the 'Data' contains the sum of the hours worked.
I'd like to use the one pivot table to produce a report showing five pie
charts (one for each employee) with only one legend. Is this even possible?

You can't get five pies into a signle chart; you can play a game with a
pie of pie chart to get two, but that's lots of hard work, with math
involved. I would make five separate pie charts as regular charts
embedded in the worksheet, not as pivot charts. I'd make one with the
first employee, then make four copies, so the size and other formats are
the same, and then remove the legend from four of them.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


EPratt wrote:

I am using a pivot table to summarize hours worked. In the Pivot Table
Wizard Layout, the first field in 'Page' determines which month to report on.
The second field in 'Page' is the employee. The 'Row' displays the type of
work done and the 'Data' contains the sum of the hours worked.
I'd like to use the one pivot table to produce a report showing five pie
charts (one for each employee) with only one legend. Is this even possible?