Multiple colors for a single series to preserve labels in a Dashboard chart

PWNA Sam Harwart

Hi!

I've got a dashboard with a simple bar chart. I'd like to have each bar labeled with a text value but still preserve the ability to edit the colors of each "series".

Current Dashboard:

If I "Swap Rows & Columns":

I want to have the coloring of the top chart with the labels like the bottom. Is there a way to do this?

PWNA Sam Harwart

Answered my own problem, but I'll post the answer here in case anyone else ever runs into this.

Using a "Stacked Column" and a modified source data layout, I was able to get the result I was looking for. Since everything except the desired value is 0, the only thing left is the single bar. Since they are now each their own series, I was able to change the colors and still use the first column for the labels.

PWNA Sam Harwart

Answered my own problem, but I'll post the answer here in case anyone else ever runs into this.

Using a "Stacked Column" and a modified source data layout, I was able to get the result I was looking for. Since everything except the desired value is 0, the only thing left is the single bar. Since they are now each their own series, I was able to change the colors and still use the first column for the labels.

PWNA Sam Harwart

@Rashmi Shekhar another Dashboard request for you :)