Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ali Baba
 
Posts: n/a
Default 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


  #2   Report Post  
syseng
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate the area under the curve using Excel? munster909 Excel Worksheet Functions 1 June 1st 05 01:38 PM
how do i calculate the area under a curve? smarty 23 Charts and Charting in Excel 1 February 23rd 05 12:44 PM
finding the area under the curve in a graph in excel rmento Excel Discussion (Misc queries) 1 February 9th 05 09:33 AM
Determine area under a curve in Excel Ken Charts and Charting in Excel 1 January 22nd 05 03:28 AM
Area Under Curve Ray Naidu Excel Worksheet Functions 2 January 15th 05 11:11 PM


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"