Coloring chart items by referencing to fix RGB-colors
If you create several charts in a workbook file or creating several charts in different workbooks you have to control, that a special item has the same color in any of these charts.
In an enterprise environment this is a special need for reporting. You have to do it manually and you have to control any chart after updating because of filtering, resorting or adding new items.
I imagine, that there could be an option button, that connects a chart to a reference file. This file can be stored locally or in an enterprise environment. The named items of a chart will be searched in a list and if the lookup fits it got its own and fix RGB-values. I would not do the refresh automatically because of performance reasons, but would include a refresh button.
In my Special case I have got a workbook with more than 60 PivotCharts controlled by 6 slicers and have a list with all country colors and a color for each product of my costumer.
Acutally I use VBA to solve this problem. I showed my smaller solution at blog (German): http://thehosblog.com/2014/10/13/excel-diagrammfarben-per-vba-zuweisen/
An included solution would be great.
This is an interesting idea. We’ll consider it during our next round of planning for a future release. In the meantime, please continue to vote on this idea.