Mar 26 2020 08:44 AM
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 ?
Mar 26 2020 10:07 AM
Solution@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.
Mar 26 2020 11:17 AM
@Jan Karel Pieterse that's exactly what i needed, you have my thanks.
Mar 26 2020 10:07 AM
Solution@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.