![]() As you can see in the screencast, when the PivotTable is filtered for the Year 2012 the line colors and markers change back to the default settings.Įven though the source range of the PivotChart remains the same, the formatting of the chart changes. The colors of the lines and the shapes of the markers were changed when the PivotTable was filtered for the Year 2011. In the example below I made a few changes to the formatting of the lines in the chart from their default settings. Why Does This Happen?Īny changes to the formatting of a data series in a PivotChart are stored in a cache inside the Excel file. VBA or macros will NOT be needed for this to work, so it should be easy for anyone to implement. This post will explain why this happens and present an alternative solution that will save you time when creating PivotCharts with customized formatting. This happens when the data is filtered by a slicer or manually filtered it in the PivotTable. I customized the colors of the lines to green and grey for the Year 2011, but the line colors change back to the default colors when I filter the data for 2012. This can be very frustrating and require you to apply the custom formatting to each possible view or slice of the data. When you apply a filter or slicer to a PivotChart the custom formatting can change with each change in the filter. This is a guest post written by my colleague Jon Acampora.
0 Comments
Leave a Reply. |