The attached spreadsheet shows my problem.
I have developed a custom color scheme for a stacked area chart. I need to create many versions of the same chart by changing the underlying data. I have tried to simply change the chart data range (under "Select data..."), from using data on the 000 tab to using data from the 100 tab. However, this includes all of the columns as data series, whereas, column A ("Year") represents the horizontal axis labels and should not be included as a series. I can manually adjust this by removing the "Year" from the set of data series and adding it back as the horizontal axis labels.
The problem is: this shifts my color scheme
. The red at the top turns blue and all of the other colors shift down one and I lose the bottom color (pink).
Suggestions for how to create a second chart with a new data set while maintaining the original color scheme are most appreciated.
Many thanks in advance,