INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Feedback
"...keep up the good work with this forum, I think this
is the best one around. ...you actually try to help
people learn for themselves. ...I commend you on providing a
very good, open learning atmosphere, where usually egos are left behind..."
Geography
Where in the world do Tek-Tips members come from?
|
How to
|
Chart Bars or Columns that change color based on data values.
Posted: 16 Jul 10
|
First remember that an Excel BAR Chart has a horizontal orientation, while an Excel COLUMN chart has a vertical orientation.
Suppose we have some simple data like this:
Region Budget
North 200
South 400
East 600
West 800
and you want to display any Budget amount in the chart less than 500 as RED and all other amounts as GREEN.
First we need to condition the data to reflect this requirement:
A B C D
1 Region Budget RED GREEN
2 North 200 =IF(B2<500,B2,0) =IF(B2>=500,B2,0)
3 South 400
4 East 600
5 West 800
The result, when you copy the formulas down thru all rows of data:
Region Budget RED GREEN
North 200 200 0
South 400 400 0
East 600 0 600
West 800 0 800
Now you create your chart, using only columns C & D (RED & GREEN) for data and column A for labels. Use the STACKED Bar or Column feature
|
Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum
|
|
 |
|
Join Tek-Tips® Today!
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Talk To Other Members- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close
