As part of this excel project I'm developing, I'm attempting to intelligently draw circles over a map image. Since, sadly, I don't see anyway to just have excel graph an equation, I've solved the circle equation for Y and have two separate columns which are the solutions.
Now, when I graph these two columns I just get the lines of the curves, but what I'd like is to fill the circles with a shaded region.
Is it possible to somehow fill the area under a curve? After some research I found some very hokey ways that work for just the positive side of the curve (http://peltiertech.com/WordPress/fill-below-an-xy-chart-series-xy-area-combo-chart/
), but I'd like something that is a) more robust and b) works for the entire circle.
Any suggestions? I'm open to VBA solutions as well.