View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Simple Charting Problem, Please

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.
--
Windows10
Office 2016