Pivot chart

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top