Pivot chart
 

Hallo,
I usually create charts based upon pivot tables and it all works fine.

Now I need to create a chart that uses the data shown on the pivot table,
plus the "total average" to be used as a benchmark.

The example of the pivot is:

Agent Average production
Joe 3000
Manuel 5000
Steven 4000
Total average 4000

I would like to have a chart that shows the average production of the agents
and the total average production. I can't get Excel 2007 to include that
last line in the chart.
Can anyone suggest a way?

Thanks
Maurizio

Pivot chart
 

Brian wrote:
Hallo,
I usually create charts based upon pivot tables and it all works fine.

Now I need to create a chart that uses the data shown on the pivot table,
plus the "total average" to be used as a benchmark.

The example of the pivot is:

Agent Average production
Joe 3000
Manuel 5000
Steven 4000
Total average 4000

I would like to have a chart that shows the average production of the
agents
and the total average production. I can't get Excel 2007 to include that
last line in the chart.
Can anyone suggest a way?

Hi there,

I suggest you abandon the pivot chart. Use a pivot table, if you like,
to crunch the data, but then lift the results using GETPIVOTDATA to a
separate area for charting.