dougf1r
asked on
Update chart data range
Hello,
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,
Todd
color-problem.xlsx
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,
Todd
color-problem.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Echo_S
Where's the "like" button? :-)
Hey dougflr, why not save your chart as a template so you can apply the color scheme to all future and past graphs on demand?
kfalandays
kfalandays
@Echo: thanks.
@kfalandays: You're missing the point.
@kfalandays: You're missing the point.
ASKER
Simple solutions are the best. Many thanks teylyn!