Embedding charts in pivot tables

[Darren]

I have a pivot table showing sales people in the first column,
products in the second and sales figures by quarter along the top
(pretty standard!).

I can create a chart from this info and step through an employee at a
time to see the data.

I would love to be able to embed a chart into the table, under the
employee name to show the data graphically, so that the result would
be a table with a series of charts. This would be dynamic so that if
I switched off certain employees from the dropdown filter at the top
of the pivot table, their info and chart would disappear, reappearing
if I switched them back on again.

Is it possible to embed a chart in this way?

Darren.

 

[Debra Dalgleish]

There's a sample file on my web site that has a chart connected to a
pivot table. Select an employee name, and the chart shows their data.

http://www.contextures.com/excelfiles.html#Pivot

Under Pivot Tables, look for Employee Time Tracking