Graphing: Stopping the downvard line
 

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?

Graphing: Stopping the downvard line
 

In each empty cell enter the formula =NA()
This will show as N/A and the chart engine will ignore it
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Khai N" wrote in message
...
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?

Graphing: Stopping the downvard line
 

On Thu, 5 Jun 2008 00:54:01 -0700, Khai N
wrote:

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