It is now completely fixed, with hopefully consistent colors throughout. If I messed something up again - likely a label or slice color for a slice that is normally too small to see on my graph - please let me know.
The pivot table that populates the graphics is also far enough out of sight that it should be very difficult to accidentally edit>>17408723Post an auction Avarice, you've earned a bug bounty and today is very green.
>>17412240This was pure stupid on my part - an earlier kludge coming back to bite me in the ass.
Not at all what you explained to me - I initially thought it was exactly what you explained to me though. Had nothing to do with the proper ranges being mapped to the graphics, or with any of the handles in the name fields being changed.
At some point before the sheet had the Filter/Sort bar added, either I or the OG Haaton edited the "himemoriluna" label on the graphs to read "luna" instead of automatically grabbing the name from her cell. And her cell only - the rest were still automatic. That label, along with the colors, ignored the sorting once it was added - and was likely never noticed because Row #35 when sorting by Div% in the three previous weeks have been Nene, Kanata, Botan - you can actually see it showing the same problem with Botan in my wallet from that week.
Now that the data is mirrored in a pivot table, hard sorted "In order" in the mirror, and the mirror is used for the graphs instead of the data itself, it will completely ignore however you choose to sort shit and will always look the same. 