Chart type not remembered in a pivot chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Devo Clubber - 29 Jun 2006 13:15 GMT

if you change a dataseries chart type e.g to line from bar within a pivot
chart, it reverts back to it’s original setting when the chart is refreshed !!

Surely this cannot be right?

tried in Office 2000,2002,2003 & 2007beta

Reply to this Message

Jon Peltier - 30 Jun 2006 05:33 GMT

It's not "right" but it's the way it's been since pivot charts came out in
Excel 2000. The conventional wisdom, from the Microsoft knowledge base, is
to record a macro the next time you repair the formatting, then rerun the
macro as needed:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q215904

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> if you change a dataseries chart type e.g to line from bar within a pivot
> chart, it reverts back to it's original setting when the chart is
[quoted text clipped - 13 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=e2129427-f8c4-4
fa1-893b-24e1740b2c27&dg=microsoft.public.excel.charting

Reply to this Message