I have a spreadsheet with data for many categories and sub-categories. In the graphs derived from the spreadsheets I have a color scheme the uses different shades of the same color for the sub-categories of each category.
For instance in the graph sub-categories for Category 1 are all shades of red, sub-categories for Category 2 are all shades of blue, etc.
With each upgrade all the subcategories are assigned new colors seemingly at random, and I have to go through every sub-category of every graph and re-assign the original colors. This takes hours.
Can upgrades be improved to retain graph color schemes?