Update Chart in Pivottable

T

Tobias

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?
 
D

Debra Dalgleish

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
 
Top