pivot table chart properties

[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

 

[Debra Dalgleish]

Loss of formatting is a known problem with pivotcharts. There's some
info in the following MSKB article, which suggests recording a macro as
you apply the formatting:

XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/?id=215904

 

[Jon Peltier]

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/
_______

 

[Jon Peltier]

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/
_______

 

[Tushar Mehta]

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

 

[Jon Peltier]

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/
_______