Update Chart in Pivottable
 

Hello

I want people to be able to update a chart in my excelfile. The chart should be "Line - Column on two axes", But when they change e.g the project they want to see it switches into the "normal" format with a only columns, I guess I could record a macro that changes this back to the format I want, but isn't there a way to keep the format?

Update Chart in Pivottable
 

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

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

Tobias wrote:
Hello,

I want people to be able to update a chart in my excelfile. The chart should be "Line - Column on two axes", But when they change e.g the project they want to see it switches into the "normal" format with a only columns, I guess I could record a macro that changes this back to the format I want, but isn't there a way to keep the format?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html