Forum Discussion
Auto toggle stacked column colors
Hi AAAAAAA
It seems there are many values in your legend field. Is Purchase type used on the legend? If you want to display only 2 colors for each actual column, what do these two colors represent for?
If your data is similar to below,
You can make a stacked colum chart like below, which has only two colors because it has only two values (Cell phone & Laptop) in the legend.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hey v-jingzhang,
Thank you for this input and sorry for replying so late!
In your example, if we added one more entry to 61701 Actual [1000 | Desktop | 61701 | Actual] (for example). There would be a new part of the stack added ontop of the dark blue laptop section. I believe we could manually change the color so it matches the light blue of cell phone below, and that would be the desired aesthetic. A two toned bar that alternates color as more entries are added to it.
That manual process though of going into the legend and telling "Desktop" to match the light blue of cell phone, so that every entry is an alternating color in relation to the entry below- Is there a way to make that happen automatically?
Thank you!