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 |
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 |
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 |
All times are GMT +1. The time now is 08:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com