I have 2 charts in the attached Dashboard that are using the same data set but are filtered slightly different. I am segmenting both charts via the same field "Lead Priority" (the field that segments by color). I want to change the color format on the 2nd chart to a different color than the 1st chart. This doesn't appear to be possible and I was wondering if someone had a workaround?
All you have to do is to duplicate "Lead Priority" and use the copy on the color shelf of your second worksheet. You will be able to set a different set of color on it without impacting the colors of the first worksheet.