LinkBack URL
About LinkBacks
Is there any way of having the columns in a bar graph change colour depending on the value? For example, red for 1-49, yellow for 50-99, green for 100+.
This is probably easy but I can't seem to find a way.
Is there any way of having the columns in a bar graph change colour depending on the value? For example, red for 1-49, yellow for 50-99, green for 100+.
This is probably easy but I can't seem to find a way.
May be something here might help?
http://peltiertech.com/Excel/Charts/...nalChart1.html
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks for the link, oldchippy. It seems that the only way involves creating a table next to the data. Not sure how effective that would be in my situation. Is it worth pursuing a VBA alternative?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks