pivot table chart properties

  • Thread starter Thread starter machiel
  • Start date Start date
M

machiel

Hi,

I have made a pie-chart out of a pivot table so i can easily change th
parameters on the fly. For clarity I would like to add some things lie
valuenames on each pie-part. I can change the chart but everytime
choose a different paramter from the drop-down box it changes back t
the old properties-setting.

Anybody got an idea on how to fix this, besides making a manual char
from the pivot
 
Alternatively, someone recently suggested putting formulas in a range
parallel to the pivot table, formulas which referred to cells in the
pivot table. Then make a chart based on these added cells, not on the
pivot table. When the pivot table updates, so does this range of
formulas, but the chart doesn't change all of its formatting.

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

I'm not smart enough to do this. There are too many possible ways to
pivot, and too many different configurations (size and contents) of
pivot table that may result. You could try using Calculated Fields in
the pivot table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
One way might be to use functions such as GETPIVOTDATA. Don't know
when that capability was introduced. An example:

=GETPIVOTDATA("b",$F$1,"a",1)+GETPIVOTDATA("b",$F$1,"a",2)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Tushar -

This is something I need to try. Anything that makes me look smarter...

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