G Guest Feb 28, 2007 #1 Is there an easy way to format the color of a bar based on it's value? Or is it only through macros that this can be achieved? Thanks.
Is there an easy way to format the color of a bar based on it's value? Or is it only through macros that this can be achieved? Thanks.
A Andy Pope Mar 1, 2007 #2 Hi, Conditional charts can be created by using multiple series. See here for more information. http://peltiertech.com/Excel/Charts/ConditionalChart1.html Cheers Andy
Hi, Conditional charts can be created by using multiple series. See here for more information. http://peltiertech.com/Excel/Charts/ConditionalChart1.html Cheers Andy
G Guest Mar 1, 2007 #3 Thanks a lot...it works great! Andy Pope said: Hi, Conditional charts can be created by using multiple series. See here for more information. http://peltiertech.com/Excel/Charts/ConditionalChart1.html Cheers Andy Click to expand...
Thanks a lot...it works great! Andy Pope said: Hi, Conditional charts can be created by using multiple series. See here for more information. http://peltiertech.com/Excel/Charts/ConditionalChart1.html Cheers Andy Click to expand...