Pivot chart

[Brian]

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

 

[Herbert Seidenberg]

Excel 2007
Charted Average
http://www.mediafire.com/file/zyfnztnzmmm/12_13_08.xlsx

 

[Herbert Seidenberg]

Excel 2007
With simplified formulas:
http://www.mediafire.com/file/ygzdi1k3klx/12_13_08.xlsx

 

[Brian]

Excel 2007
With simplified formulas:
http://www.mediafire.com/file/ygzdi1k3klx/12_13_08.xlsx

Thanks a lot, that is exactly the chart I was looking for!

Anyway, the first link didn't work.

I downloaded the 2nd file and I'll have to study it rather hard. I thought
it would be a little bit simpler... I guess now I know what to do during the
next couple of weekends

Thanks again

Maurizio