Infinite opportunities?  Endless problems?  Limited resources?  Talk to us!
Operations
Consulting
Software
Consulting
Publishing and
Training
Applied
Solutions
Excel add-ins
and tutorials
Charts Excel and VBA
Case Studies
VBA
tutorials
PowerPoint
Add-Ins
Miscellenia

How the PLOT program does what it does

The PLOT software always adds a new worksheet to the active workbook and uses this new sheet for its calculations and the final graph.

In creating the data for the graph, it starts by checking the function at some number of x values.  How many values it uses to start is controlled by the dialog box entry 'minimum data points to start with.'  It subsequently doubles the number of data points it uses.  However, it does not allocate these new data points in an equidistant fashion as the first time around.  Instead it uses the information about the curvature of the graph at each of earlier data points and uses more points in the areas where the curvature is greater.

The program keeps on doubling the data points it uses until it has more than the number specified in the dialog box entry 'Maximum (to stop with).'

It creates the graph as an embedded chart object in the new worksheet added to the workbook.

 

For custom technology solutions, operations consulting, or training contact web-underscore-contact@tushar-hyphen-mehta-dot-cee-oh-em.
By accessing any page or link on this web site other than this page, you agree to the terms and conditions.

Ads from amazon.com

[Optional] Survey (current rating of site: 3.7 out of 4)  If you will take a moment to provide your comments, it will help improve the site both for you, and for other visitors.

On a scale of 4 (just what I need)
to zero (totally useless)

How do you rate the information

on this page?

  on this site?

[Optional]

Your name
Your email address
Other comments
 
Monitor page
for changes
    
   it's private  

by ChangeDetection
A comment selected at random:

 

 

Copyright © 2000-2008 Tushar Mehta.
Send comments and suggestions about the web site to webmaster@tushar-hyphen-mehta-dot-cee-oh-em
Last edited April 14, 2008