Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Area
I know I have done before, but can't seem to remember how to get doable
results. I want to be able to have 3 different background colors on a chart Green, Yellow, and Red. Then 3 columns that are used to show different numbers. The background colors are to help the viewer see quickly if their numbers are in a valid range. -- Thanks, Nikki |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Area
Nikki -
Here's one way: http://peltiertech.com/Excel/ChartsH...orizBands.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Nikki" wrote in message ... I know I have done before, but can't seem to remember how to get doable results. I want to be able to have 3 different background colors on a chart Green, Yellow, and Red. Then 3 columns that are used to show different numbers. The background colors are to help the viewer see quickly if their numbers are in a valid range. -- Thanks, Nikki |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Area
-- Thanks for helping me find a solution- I think this is the one I happened upon last time I did it- so you have helped me twice. Thanks, Nikki "Jon Peltier" wrote: Nikki - Here's one way: http://peltiertech.com/Excel/ChartsH...orizBands.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Nikki" wrote in message ... I know I have done before, but can't seem to remember how to get doable results. I want to be able to have 3 different background colors on a chart Green, Yellow, and Red. Then 3 columns that are used to show different numbers. The background colors are to help the viewer see quickly if their numbers are in a valid range. -- Thanks, Nikki |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you show plot area only-no chart area | Charts and Charting in Excel | |||
Stacked area and area chart combo | Charts and Charting in Excel | |||
Resize plot area in a chart area | Excel Discussion (Misc queries) | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel |