How to lock combination chart in pivot chart?
 

I have a pivot chart formated as bars with only one serie formated as line
and every time I manipulate the chart this line serie miss the configuration,
returning as a bar chart.

Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as
you apply the formatting:

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



Marcos Novaki wrote:
I have a pivot chart formated as bars with only one serie formated as line
and every time I manipulate the chart this line serie miss the configuration,
returning as a bar chart.


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