Pivot Chart

A

Anna

In Pivotchart, Everytime I press the refresh button,How
can I keep the same chart type I like? (but not a default
chart). Thanks.
 
T

Tushar Mehta

XL retains only certain aspects of a customized PivotChart. One option
would be to create a macro that does the customization you want. The
other is to create a normal chart from the data in a PT.

--
Regards,

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