Google Sheets - How to preserve colors of each series from changing when inserting new data in Chart Editor?

by caeldom   Last Updated June 13, 2019 04:03 AM

This issue occurs on every chart type. As an example, I have a pie chart created from a long table of data where each column is assigned a specific text color, so each slice of the pie corresponds to the color of that column. I maintain this color coding on various other graphs of the same data to aid in reading the data.

When I insert a new column into the table data, I want to assign it a new color, and have its slice take that color. The new data is inserted into the series of the pie chart. However, the series will not keep their assigned colors, instead the inserted series will take the color of the series that was in its place, causing a domino effect as every series after will shift its color. The last series will have a new color. As such all the slices in the chart after the inserted slice will no longer correspond to the color of its column.

Chart before and after inserting new data

I then have to manually change each series back to its original assigned color which is extremely time-consuming and frustrating every time I want to insert new data.

How can I preserve the color of each slice/series so that the colors don't all change when I insert new data?

Related Questions

Updated March 03, 2018 02:03 AM

Updated January 18, 2019 09:03 AM

Updated February 24, 2018 16:03 PM

Updated March 09, 2019 20:03 PM

Updated November 05, 2017 03:03 AM