Forum Discussion
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 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?
8 Replies
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.
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.
Hi MichaelSX,
There are already many colors to identify these small boxes. What are the conditions you want to apply?
Best Regards,
Dale
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.
