ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Drawing points on a three colored chart region (https://www.excelbanter.com/charts-charting-excel/232118-drawing-points-three-colored-chart-region.html)

Aldo

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.



All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com