Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Drawing points on a three colored chart region
Hi guys,
I need to create a chart that shows a group of points, like: Axis x goes from 0.0% to 100% Axis y goes from 0.0% to 500% Point 1: x=5% y=30% Point 2: x=15% y=22% Point 3: x=25% y=75% Point 4: x=50% y=25% Point 5: x=60% y=80% This is easy to do in Excel, the problem is that I have to paint the chart region in three different colors, green, yellow and red in order to show to the user how critical is each point (depending on the color€¦). I must let the user to decide the limits of the region of each color. Is there any chance to achieve that in Excel? Thanks in advance for any help, Aldo. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Drawing points on a three colored chart region
Hi,
Maybe you can use this technique to colour regions of the chart http://peltiertech.com/Excel/ChartsH...orizBands.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Aldo" wrote in message ... Hi guys, I need to create a chart that shows a group of points, like: Axis x goes from 0.0% to 100% Axis y goes from 0.0% to 500% Point 1: x=5% y=30% Point 2: x=15% y=22% Point 3: x=25% y=75% Point 4: x=50% y=25% Point 5: x=60% y=80% This is easy to do in Excel, the problem is that I have to paint the chart region in three different colors, green, yellow and red in order to show to the user how critical is each point (depending on the color€¦). I must let the user to decide the limits of the region of each color. Is there any chance to achieve that in Excel? Thanks in advance for any help, Aldo. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar chart by division, department, region date | Charts and Charting in Excel | |||
Create a solution region on a chart | Charts and Charting in Excel | |||
How do I shade a region between two selected points on the x axis? | Charts and Charting in Excel | |||
Can I combine points in a scatter diagram without drawing by hand | Excel Discussion (Misc queries) | |||
Line Drawing Between Separated Data Points ? | Charts and Charting in Excel |