Column chart - Change color/value based on original y value

**leossj433** · 11-14-2012, 11:42 AM

Hello, I need some help with column graphs.

I have 2 columns of data which I use to make a column graph ( see attached file).

What I want to do is change the color ("solid fill") of each column, based on a condition, if let's say the y-value is less than 85, make the column red, else leave it as it is. Also, there's cases where there's no y-value at all, in such case I'd like the column to get a value of 100 and fill it with gray color.

I'm guessing I need to use a VBA script for this that would iterate over each column and format it based on the conditions I mentioned above. Not really familiar with VBA though, could you point me to the right direction ?

Thank you for your time,
Leo

**ptm0412** · 11-14-2012, 12:11 PM

You could separate data into 3 column: Less than 85, More than or equal to 85, and blank. Then make a stacked column chart.
See attached file.MulticolorColumn.xlsx

**leossj433** · 11-14-2012, 12:23 PM

Yes, that would work

. However, I'll need to do about 30 graphs like this, and each column will have couple thousands of rows, so I was hoping to achieve this through VBA, If I can't figure it out that way though I'll probably do it your way. Thanks ptm