Lock pivot chart type?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robotman@gmail.com - 17 Nov 2006 22:41 GMT

I have a pivot chart set up and have it as a "column - line 2-axis"
chart type. Everytime I choose something different to display in the
chart, it reverts back to a plain ol' column chart type.

I wrote a quick macro to detect the pivot chart change and set it to
the "column-line 2-axis" chart type, BUT is there an easier way to lock
the chart type without using a macro?

Thanks.

John

Reply to this Message

Debra Dalgleish - 18 Nov 2006 01:40 GMT

This is a known problem with pivot charts. There's information in the
following MSKB article, which suggests the solution you've already used
-- using a macro to reapply the formatting:

Changing a PivotChart removes series formatting in Excel
http://support.microsoft.com/?id=215904

> I have a pivot chart set up and have it as a "column - line 2-axis"
> chart type. Everytime I choose something different to display in the
[quoted text clipped - 7 lines]
>
> John

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message