Hi Bob,
Am Sun, 25 Dec 2016 10:56:29 -0500 schrieb Bob:
Plotting Blood p:
Column A has dates.
Column B has pressure.
Really a simple setup.
Scatter graph is desired, with straight lines between the actual
points.
Lets say I have 10 dates.
If I select these 10 to plot, no problem.
Does it all nicely.
But if I select, e.g., 15 rows to Plot, with
the last five being Blank, it won't do it.
name the ranges of x and y values and use these names for the
chart.Then your chart is always present with the current data.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYI-fCz3P6SW4iUuyQ
Regards
Claus B.
Making this data range 'dynamic' would be best so it self-sizes and its
chart auto-updates accordingly!
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion