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...;EN-US;Q215904

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


"Devo Clubber" <DevoClubber@discussions.microsoft.com> wrote in message
news:E2129427-F8C4-4FA1-893B-24E1740B2C27@microsoft.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
> refreshed !!
>
> Surely this cannot be right?
>
> tried in Office 2000,2002,2003 & 2007beta
>
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...excel.charting