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.