Creating pattern area under part of an x-y chart
In Excel, I am drawing normal distribution charts (your typical bell-shaped curve) using a column of x values and a column of y values, and selecting x-y chart selection with smoothed line. I need to shade a portion of the area under the chart (typically from one x value to the other). Is there some way in Excel's tools to generate a pattern fill under the curve, between specified x limits? Now, I'm just using Excel's drawing tool , Autoshapes, Freeform line, and trying to create an area that just exactly fits under the curve, but it's difficult to get all the points to line up under the curve correctly.
I can, of course, shade any closed area made with the drawing tool, but how to shade part of the area under the normal curve?
|