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

Originally Posted by bj

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

>[/color]

I have a similar problem where this do not work because the cell has a function but no value.

The function is as follows:
=IF(P133="";"";N133/(D133*2*$T$13)

And it leaves a blank field if the other field is blank, but if it isnt it calculates a value. My problem is that even though the field is left blank the line will be showing 0 on my graph.

Are there any solutions for this problem?

Originally Posted by Ctharth

I have a similar problem where this do not work because the cell has a function but no value.

The function is as follows:
=IF(P133="";"";N133/(D133*2*$T$13)

And it leaves a blank field if the other field is blank, but if it isnt it calculates a value. My problem is that even though the field is left blank the line will be showing 0 on my graph.

Are there any solutions for this problem?

Well IŽll be darned I found the solution myself. I just Changed the formula to

=IF(P133="";NA();N133/(D133*2*$T$13)

Offcourse the fields blank, but the values wont show up as 0.