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