Forum Discussion

MichaelSX's avatar
MichaelSX
Frequent Visitor
8 years ago
Solved

Conditional Formatting a Stacked Column Chart

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 in...
Need Help
MichaelSX's avatar
MichaelSX
Frequent Visitor
8 years ago

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's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi MichaelSX,

 

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

Conditional_Formatting_a_Stacked_Column_Chart

 

 

Best Regards,

Dale

  • MichaelSX's avatar
    MichaelSX
    Frequent Visitor
    7 years ago

    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.