Drawing points on a three colored chart region

A

Aldo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010 - Line Chart with Mulitiple Data Sets 1
A line chart 3
Scatter chart with categories on x-Axis 2
Data Labels xy scatter plot 1
Create a solution region on a chart 3
Conditionally Format Data Points in Line Chart 0
Make a mekko chart in Excel 2007 in three easy Steps 1
Line Chart Excel 2007 0

Top