Pivot Chart Total Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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/
_______
 
Back
Top