Stacled Bar Chart Question

[#1]

There doesn't seem to be a proper solution yet for changing a stacked bar chart colors.

Essentially, I have a stacked bar chart with three different measures. Measure 1 is blue, Measure 2 is yellow, and measure 3 is red. They are stacked correctly with the related data so it appears correctly on the graph. I'm looking to change the colors of the different stacks. For instance, I'd like measure 3 to be some other color like green, anything but red. Is there an easy way to do this? Has anyone figured it out?

Thanks,

Akhil

[Anonymous · Accepted solution]

technically there is now way you can do that. But there is a work around for that. Add the dimension present in the bar chart as a measure too. Now switch your measure up and down that would eliminate red color. Hope that helps