|
Posted to microsoft.public.excel.misc
|
|
|
Conditional Formatting Colour in a Column Graph (Excel 2003)
On May 20, 10:17*am, wrote:
On May 20, 9:48*am, "Bob Phillips" wrote:
Add helper columns to get values for those ranges, such
C2: =IF(B2<80,B2,NA())
D2: =IF(AND(B2=80,B2<100),B2,NA())
and so on, copy these down and then chart columns A, C, D etc. This will
give you multiple series and you can colour each series to your preferred
colour.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
wrote in message
...
I have created a column graph, and I know I can manually colour the
columns to reflect their values.
I was wondering though if I can get them to automatically colour based
on the values being used
to create the columns
i.e.
a value from 0-79 would result in a red column
a value from 80-99 woudl result in a yellow column
a value of 100 would result in a green column
I've heard it can be done through VB, but unless the instructions were
super detailed for me to follow I would be lost!
Thanks for any help that you can give.- Hide quoted text -
- Show quoted text -
Thanks Bob, I'm a little bit lost ( and a basic excel user) - what
will those formulas do exactly?
Right now I guess I just have one series, and it takes the info from
each cell - there are only 4, that have the numbers in them,
i.e.34, 55, 81, 100.
Should I be doing this another way?- Hide quoted text -
- Show quoted text -
Bob? anyone?
|