Forum Discussion
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 / m...
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.
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.
JKPieterse that's exactly what i needed, you have my thanks.