Forum Discussion

Rb_01's avatar
Rb_01
Copper Contributor
Mar 26, 2020
Solved

Synchronize the colors of multiple PivotCharts

Hello everyone,

 

I created an automated Excel system which allows with a simple database extraction to feed a report mainly composed of pivot charts. I added segments to sort the data by weeks / months / years.


The problem is that when I filter my report the colors of the categories on the PivotCharts no longer match each other. In addition, some PivotCharts have different categories from others.

 

So i would like to assign a color to each category which will not change when I filter my report. But I do not know how.

 

Any idea ?

 

thank you in advance
excel
Formulas and Functions
Macros and VBA
  • JKPieterse's avatar
    JKPieterse
    Mar 26, 2020

    Rb_01 If you use PowerPivot and a properly designed data model you can set the pivottables to display rows with no data (they would appear in a chart as zero-width bars). Filtering then does not affect the displayed categories and hence the colors stay the same. See attached example.

2 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Mar 26, 2020

    Rb_01 If you use PowerPivot and a properly designed data model you can set the pivottables to display rows with no data (they would appear in a chart as zero-width bars). Filtering then does not affect the displayed categories and hence the colors stay the same. See attached example.