charting blank spots

[mark]

Hi.

I'm working with automating a chart that the user has
filled in by hand, in the past.

The chart displays a years worth of data, and she just
manually filled in the new month's data for each
successive month.

One way to automate things is to fill in formulas that
result in the proper data for months that have transpired,
and "" for months yet to come.

The problem with this is that the chart displays the text
blank, "", as a 0 . One of the series in the chart is
displayed with a line, and for the months that have not
yet occurred, the line goes down to 0, and then stays
there.

Is there a setting to prevent the chart from dispaying a
text item as 0?

If not, I can programatically update the thing, but it
would be simpler not to.

 

[Guest]

Using "" does make the graph take a nose dive. Use the
function na() instead as your graph will treat this
command as a null.

 

[mark]

Using "" does make the graph take a nose dive. Use the

function na()

Thanks.