Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Colour gradients in charts
Hello all.
Is it possible to create a colour gradient between two linear boundaries parallel to X axis, in any of these ways? A single colour ranging from light to dark or three colours blending from green through amber to red. Have tried inserting a filled rectangle and also importing an appropriate image created in a drawing package. These are okay to a degree but can only be placed in front of the chart covering the data or behind the chart and out of sight. What is needed is a means of visually indicating that all is well, or there is something unusual happening, or that a dangerous condition has developed when data plots into green, amber or red zones. All suggestions would be appreciated. Bayside |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Colour gradients in charts
Hi,
Try a variation on Jon's example. http://peltiertech.com/Excel/Charts/...ticalBand.html Cheers Andy Ken wrote: Hello all. Is it possible to create a colour gradient between two linear boundaries parallel to X axis, in any of these ways? A single colour ranging from light to dark or three colours blending from green through amber to red. Have tried inserting a filled rectangle and also importing an appropriate image created in a drawing package. These are okay to a degree but can only be placed in front of the chart covering the data or behind the chart and out of sight. What is needed is a means of visually indicating that all is well, or there is something unusual happening, or that a dangerous condition has developed when data plots into green, amber or red zones. All suggestions would be appreciated. Bayside -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Colour gradients in charts
On Wed, 6 Dec 2006, in microsoft.public.excel.charting,
Ken said: Is it possible to create a colour gradient between two linear boundaries parallel to X axis, in any of these ways? A single colour ranging from light to dark or three colours blending from green through amber to red. Have tried inserting a filled rectangle and also importing an appropriate image created in a drawing package. These are okay to a degree but can only be placed in front of the chart covering the data or behind the chart and out of sight. You say "behind the chart and out of sight". Did you import the picture into the plot area? Format Plot Area.. Fill Effects.. Picture.. Select Picture That should get you your picture in the plot area of the chart, but behind the data. If you do... Format Chart Area.. Fill Effects.. Picture.. Select Picture ....that puts the picture in the background behind the plot area instead. That's still not fatal if you make the plot area itself transparent, but putting it in the plot area's better if you want the picture to line up with actual data. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alternating cell colour | New Users to Excel | |||
Can I import a new colour into the options for creating charts? | Charts and Charting in Excel | |||
My links (bar charts) print in b&w but they should be in colour | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
I'm loosing colour when copying charts from excel to word. | Charts and Charting in Excel |