Conditional Formatting of Column Graph

[vukodlak]

I did some searching around I wasn't able to find a solution.

This is what my data looks like:
Category V1 V2
A 2.1 .98
B 1.8 .72
C 5.6 .75
D 1.1 .85

What I want is a bar going up for each category to the height of V1, and it would be shaded conditionally according to V2. The column part isn't a problem, I couldn't find a way to conditionally fill in the bars with colors depending on some other variable.

Does anyone have any suggestions on how to create what I want?

Thanks for your help!

 

[PaddyD]

hi - welcome to the board.

have a look at the techniques here:

http://peltiertech.com/Excel/Charts/

..I'd probably play with a stacked chart, using a dummy data series to drive the 2 colours of the V1

 

[shemayisroel]

I've used these and it really helps

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

 

[vukodlak]

Thanks for the links. I was able to find something there that was effective enough at doing what I wanted.