This issue occurs in 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.
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?
