Hans -

You've discovered that pivot charts aren't very smart. They chart all
the individual data in a pivot chart, and none of the totals or subtotals.

Have you tried grouping the data, or perhaps taking out fields which
subdivide other fields, for example, the quarters in the bad
representation below:

2003 Q1
Q2
Q3
Q4
2004 Q1
Q2
Q3
Q4
2005 Q1
Q2
Q3
Q4


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Hans wrote:

Hi,

I have a standard pivot table/chart combination displaying project
costing&budget data for several projects. I would like to plot in the chart
the sum of budgets and/or costs over different combinations of projects. But
I only succeed in charting the individual entries per project.

Any advice?

Thanks,