Hi, not sure there is a solution to this, but gotta ask.
I want to use a certain color theme in my workbook that can apply to the top n values in the bubble or donut chart. Right now its pretty random, and I know if I change the color for what shows in a certain filter arrangement, if the filter changes and the top n change, then the colors are off again. If the filter is set for say top 5, then I really don't care what color the 6th is until it joins the top 5. If I am filtering 100 values, I really don't want to have to adjust the color for all 100. I know this is a big ask, but is it at all even a pipe dream?
Laura
