Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Changing a PivotChart removes series formatting in Excel
Article ID: 215904 - View products that this article applies to.
This article was previously published under Q215904
When you perform any of the following pivot operations in your PivotChart or the underlying PivotTable report, one or more of your data series lose their formatting:
When you perform a pivot operation in a PivotChart or the underlying PivotTable report, Microsoft Excel removes, and then adds the data series back to the chart. When this occurs, all formatting that you have applied to the data series in the chart is lost.
To work around this problem, you can record a Visual Basic for Applications macro that saves the changes that you make to your PivotChart. Then, you can run the macro to reapply the formatting as necessary.
For more information about how to record a macro in Excel, click Microsoft Excel Help on the Help menu, type Record a macro in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
When you perform a pivot operation in your PivotChart, all of the following settings are lost: