Greetings, I am using line graphs to show temperature, humidity and such in a cleanroom environment. We have acceptable limits or "ranges" for these values, for example we like to see the humidity between 30 and 40%. I have been tasked to mofdify these charts with color bands that would reflect if these reading are staying with in tolerance. For example: a green band between 30 & 40, yellow bands between 25 -30 & 40 - 45, and red bands between 0 - 25 & 45 - 100. Changing the background color is pretty straightforward for a single color or picture or whatever, but what about bands of color? Is it possible to do this in Excel? I am thinking that I could probably do it by making a JPEG that I could use, but I am afraid it would be hard to size it just right and then that the bands would not stay correct if I were to resize the graph or something. Right now I just used some autoshapes with the transparencies set to reveal the lines behind them, but it doesn't look top notch. Anyone have any ideas? Thanks for your input
-
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.
Color "range" bands in graphs
- Thread starter rickblunt
- Start date
VoG
Legend
- Joined
- Jun 19, 2002
- Messages
- 63,650
Perhaps you want a conditional chart - see http://www.peltiertech.com/Excel/Charts/ConditionalChart1.html
Upvote
0
Hmmm.... Pretty cool idea, not sure it would work for this particular need (I have to make it so that a non-technical person can see if the numbers are good or bad) it would work if I was reading the chart. I can see me using this tip on some other things though, and it gets me thinking of new angles. Thanks for the ideas.
Upvote
0
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
Hi
You could do this (assuming I am understanding what you want) by using a secondary stacked bar chart to hold the bands (with 0 gap and 100% overlap so that the points all become one band).
I've PM'ed you - if you can send me a sample of the data and your current chart I'll show you what I think will answer your question (I expect Jon Peltier has this somewhere on his site so your other option is just to look over the peltiertech site until you find the answer).
You could do this (assuming I am understanding what you want) by using a secondary stacked bar chart to hold the bands (with 0 gap and 100% overlap so that the points all become one band).
I've PM'ed you - if you can send me a sample of the data and your current chart I'll show you what I think will answer your question (I expect Jon Peltier has this somewhere on his site so your other option is just to look over the peltiertech site until you find the answer).
Upvote
0
Jon Peltier
MrExcel MVP
- Joined
- May 14, 2003
- Messages
- 5,318
- Office Version
- 365
- Platform
- Windows
- MacOS
Horizontally Banded Chart Background
http://peltiertech.com/Excel/ChartsHowTo/HorizBands.html
http://peltiertech.com/Excel/ChartsHowTo/HorizBands.html
Upvote
0
Sweet! This should do it perfectly, never thought about the secondary axis angle. And once again all you guru's have got me thinking about a whole mess of stuff that I may have to go back and upgrade...... Cool website too by the way, so much more to learn. Thanks to all for the help.
Upvote
0
Similar threads
- Question
