Graphing: Stopping the downvard line

[Khai N]

Hi,
when generating a line graph with a range of values in a colum and only some
values entered in the range (that is, the range include empty cells), the
line graph draws a steep down line to the zero value. How can this be
avoided, i.e. the graph stops before the empty colum and not continue to draw
the zero value on the category axis?

 

[Bernard Liengme]

In each empty cell enter the formula =NA()
This will show as N/A and the chart engine will ignore it
best wishes

 

[Ron Rosenfeld]

Hi,
when generating a line graph with a range of values in a colum and only some
values entered in the range (that is, the range include empty cells), the
line graph draws a steep down line to the zero value. How can this be
avoided, i.e. the graph stops before the empty colum and not continue to draw
the zero value on the category axis?

In general, if the cell contains the NA error value, the graphing engine will
"ignore" it. So the range you are graphing needs to be set up that way.
Exactly how would depend on data you have not supplied, but, in general, if
your values are being computed by a formula, then:

=IF(your_formula="blank",NA(),your_formula)

--ron