Is it possible to use conditional formatting with charts? I.e. I would like to change the color of a chart depending on the value. If a bar is greater than 80% than I want a green color. If it is 20% or less I want a red color, etc. Is this possible?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting in Charts
- Thread starter jmathew
- Start date
Damon Ostrander
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 4,239
Hi jmathew,
Yes, this is possible, and there are several ways to accomplish it. I have an example I could email you. Simply email me your request, or PM me with your email address.
Damon
Yes, this is possible, and there are several ways to accomplish it. I have an example I could email you. Simply email me your request, or PM me with your email address.
Damon
Upvote
0
Jon Peltier
MrExcel MVP
- Joined
- May 14, 2003
- Messages
- 5,316
- Office Version
- 365
- Platform
- Windows
- MacOS
Simple Conditional Charts in Excel
http://peltiertech.com/Excel/Charts/ConditionalChart1.html
http://peltiertech.com/Excel/Charts/ConditionalChart1.html
Upvote
0
Similar threads
- Solved
