Line Drawing Between Separated Data Points ?
 

Hello:

Have a chart made from a table that has bolood pressure readings as a
function of dates.

Some dates are skipped.

The chart generated now connects a line between all the dates points that
are there, sequentially,
irrespective of whether there are points for all the (daily) dates.

Is it possible for the generated chart to have the line missing for dates
for which there is no data, and then to resume connecting the dots between
actual data ponts ?

Graph looks funny for data points connected for each day, which is what I
want of course, and then a line connecting two points perhaps a week apart
(for when on vacation with no data).

Thanks,
Bob

goto
<tools<options<chart
and select "not plotted for active chart

"Robert11" wrote:

Hello:

Have a chart made from a table that has bolood pressure readings as a
function of dates.

Some dates are skipped.

The chart generated now connects a line between all the dates points that
are there, sequentially,
irrespective of whether there are points for all the (daily) dates.

Is it possible for the generated chart to have the line missing for dates
for which there is no data, and then to resume connecting the dots between
actual data ponts ?

Graph looks funny for data points connected for each day, which is what I
want of course, and then a line connecting two points perhaps a week apart
(for when on vacation with no data).

Thanks,
Bob

Hi,

In order to break the line for dates you have not recorded you will have
provide at least 1 extra data point.

Here is a data set for the 1st 10 days in January. Where no reading was
taken for the 4th to the 6th. Your chart will still connect the 3rd to
the 7th.
01-Jan-05 1
02-Jan-05 1
03-Jan-05 1
07-Jan-05 1
08-Jan-05 1
09-Jan-05 1
10-Jan-05 1

So to break the line you need to add a empty date.
01-Jan-05 1
02-Jan-05 1
03-Jan-05 1
03-Jan-05
07-Jan-05 1
08-Jan-05 1
09-Jan-05 1
10-Jan-05 1

This will cause the line to break if your chart option is set to 'Not
plotted (leave gaps)'. To check and set this select the chart and use
the menu Tools Options Chart.

Cheers
Andy

Robert11 wrote:
Hello:

Have a chart made from a table that has bolood pressure readings as a
function of dates.

Some dates are skipped.

The chart generated now connects a line between all the dates points that
are there, sequentially,
irrespective of whether there are points for all the (daily) dates.

Is it possible for the generated chart to have the line missing for dates
for which there is no data, and then to resume connecting the dots between
actual data ponts ?

Graph looks funny for data points connected for each day, which is what I
want of course, and then a line connecting two points perhaps a week apart
(for when on vacation with no data).

Thanks,
Bob



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info