Hi
I'm using Excel to plot math graphs, specifically numerical integrations.
Thanks to an earlier post from Jon Peltier I've found that it's better to use
the XY scatter chart rather than a simple line graph for this purpose -
although you lose the area fill-in feature, but that's a cosmetic problem!
Now can anyone help me to find a way of preventing Excel from plotting
unwanted values? The point here is that the table of X and Y value is set up
as 10000 row columns, but only part of this is used depending on the limits
of the integral and/or the size of the iterations, both of which are
adjustable by formula. So part of the X scale is often out of range, or not
required.
There is an option to leave blank cells which are empty, but since my cells
all have a formula in them, even when it's set by formula to zero or "",
Excel plots them as unwanted points on my graph!
Another way of solving this would be if I could use a formula to set the
Data Range, rather than just just fix it as $B$10:$C$10000.
The only way I've found to do this so far is to manually change the Data
Range each time I change the integral limits. As this needs to often, it's a
real drag!
Any advice greatly appreciated.