Jun 11 2022 01:36 PM - edited Jun 11 2022 01:37 PM
In the attached screenshot you can see where I've tried to shade a chart and rather than continuous shades, it applies them haphazardly.
This seems to be an effect over time... where I delete and add new chart elements, and want it to reassign the colors from scratch, but it seems to have some memory of previous assignments.
As I constantly add and delete from this chart, I don't want to make the chart from scratch, and would rather have it forget whatever previous states, and assign colors continuously across the chart.
Ideas?
... using MacOS Excel version 16.61.1
Jun 13 2022 01:53 PM
Jun 14 2022 09:56 AM
To explain this problem in a different way:
As time go on, as the "Legend..." list is added to and deleted from, this is no longer the case. Especially when a continuous shading is selected, and you get a hap-hazard assignment of colors when compared to the listed series. Not quite hap-hazard: it looks to assign the first element to some nth color (not the first listed color), and cycle through the colors from there.
I see this in other ways too: I'd also expect "option+up/down" arrow to traverse elements in the series in the same order as listed in the "Legend..." list. That order is lost too.
I also see an occasional error that is very similar: while the chart elements are shown in the chart properly (in the order listed in the "Legend..." list), a data table at the bottom will sometimes place an item in the middle of the chart at the end of the data table. This is fairly rare (once a month).
Jun 14 2022 01:43 PM
Jun 15 2022 04:23 PM
Jun 16 2022 09:23 AM