Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart Backgrounds HELP!!!!
Hello,
I'm trying to design some MI and I was wondering if the Chart background can be multi coloured based on the value of the scale. For example on a chart, the background inbetween scale 0-20 is green, 20-40 is amber and over 40 red. Any help much appreciated, its for a Risk MI report. Thanks Brian Manchester, UK |
#2
|
|||
|
|||
Hi Brian,
Have a look at a couple of Jon's examples, hopefully you can adapt the principle. http://peltiertech.com/Excel/Charts/...ticalBand.html http://peltiertech.com/Excel/Charts/...ackground.html Cheers Andy Co-op Bank wrote: Hello, I'm trying to design some MI and I was wondering if the Chart background can be multi coloured based on the value of the scale. For example on a chart, the background inbetween scale 0-20 is green, 20-40 is amber and over 40 red. Any help much appreciated, its for a Risk MI report. Thanks Brian Manchester, UK -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
You may be able to use this somehow
http://peltiertech.com/Excel/Charts/XYAreaChart.html "Co-op Bank" wrote in message ... Hello, I'm trying to design some MI and I was wondering if the Chart background can be multi coloured based on the value of the scale. For example on a chart, the background inbetween scale 0-20 is green, 20-40 is amber and over 40 red. Any help much appreciated, its for a Risk MI report. Thanks Brian Manchester, UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Paste a chart as a link? | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |