Conditional Formatting a Stacked Column Chart

[MichaelSX]

I have a stacked column chart. My data has a series of dates with various count for different products on these dates. On the Axis there are dates. For values I have the count of the products. The intention is to show how many of each product is sold on each day.

I want to change the colour of individual projects within a stacked column that meet certain criteria. As far as I can tell I can only recolour single value column charts. Is there a way to accomplish my goals?

[boyerusmc]

I'm having the same challenge. I want to retain the colors above the $0 line, but want anything below (over budget) to be red.

[MichaelSX]

I ended up using a multi-selection filter to get an acceptable result. I'm still curious to know if its possible to do it the way I wanted to.

[v-jiascu-msft]

Hi @MichaelSX,

There are already many colors to identify these small boxes. What are the conditions you want to apply?

Best Regards,

Dale

[MichaelSX]

I don't want to manually colour each column, I want them to be coloured depending on a value from the table (IE: Complete, Incomplete). I would want all columns meeting certain criteria to turn green.

[v-jiascu-msft · Accepted solution]

Hi @MichaelSX,

I would suggest you vote up this idea.

Best Regards,

Dale

[blitwak]

Hi @v-jiascu-msft, @MichaelSX 

Did you resolve this?

Thanks

[MichaelSX]

IIRC I had to use a make shift solution to accomplish my goal

[blitwak]

Which shift solution?

Can you explain me, please?

Thanks in advance!

---

@MichaelSX wrote:

IIRC I had to use a make shift solution to accomplish my goal

---