ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pivot Chart Formatting (https://www.excelbanter.com/charts-charting-excel/110466-pivot-chart-formatting.html)

[email protected]

Pivot Chart Formatting
 
Hi guys! Does anybody know if there has been any update regarding this
issue (below), or you still workaround with macros?

Microsoft admits they goofed that one up:

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


They suggest you record a macro, so you can reapply the format whenever
the pivot
table is updated.


Jon Peltier

Pivot Chart Formatting
 
It still does this in 2003. I haven't tried in 2007, where I know they've
made some improvements to pivot charts.

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


wrote in message
oups.com...
Hi guys! Does anybody know if there has been any update regarding this
issue (below), or you still workaround with macros?

Microsoft admits they goofed that one up:

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


They suggest you record a macro, so you can reapply the format whenever
the pivot
table is updated.





All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com