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.

In my opinion the only way to achieve this is using Shapes through VBA, but I think it's a hell of a job to position it correctly.... I'll give it a quick look.

Could you show the sample worksheet?