ExcelBanter - Area under the curve

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Area under the curve (https://www.excelbanter.com/charts-charting-excel/40761-area-under-curve.html)

Ali Baba

Area under the curve

Jon Peltier used a VBA technique to fill the area under the curve. It works
with me fine but if the value of the Y coordinate is below 0.001 then the the
procedure crashes.

Is there a way to correct the procedure??

See this chart for illustration
http://phpaw.com/myscrpit/milt-up/jp...1124275474.jpg

Link to Jon Peltier's page
http://peltiertech.com/Excel/Charts/VBAdraw.html

syseng

Thanks Ali Baba. I will work through the info yo sent. Looks like it may
solve my problem.

syseng

"Ali Baba" wrote:

Jon Peltier used a VBA technique to fill the area under the curve. It works
with me fine but if the value of the Y coordinate is below 0.001 then the the
procedure crashes.

Is there a way to correct the procedure??

See this chart for illustration
http://phpaw.com/myscrpit/milt-up/jp...1124275474.jpg

Link to Jon Peltier's page
http://peltiertech.com/Excel/Charts/VBAdraw.html

All times are GMT +1. The time now is 11:21 AM.