You could record the steps as you manually apply the chart type.
Then, add that code to the Worksheet_PivotTableUpdate event.
BorisS wrote:
I'd like to have a pivotchart which is the line on 2 axes type, but every
time I change something in the pivotchart, it changes back to its default.
Is there some code that I can have which works on any refresh/change of the
chart, which would automatically make the chart type go back to line on 2
axes?
Thanks.
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html