Displaying Zero Values in a Chart

[ajames]

I have a spreadsheet that picks up monthly data from another spreadshee
and displays the data in a table and a chart. It obviously has formula
in for each month of the year and months April-Dec are returning th
value of '0', since the data has yet to be input into the othe
spreadsheet for these months.
The problem is that my line graph looks like it plummets to 0 in April
whereas in fact I would just like the line to stop at March - how do
do this?
I have tried putting in an IF<0 formula, but "" still plots as 0!
The Charts tab on Options has the check box of 'plot empty cells as no
plotted' checked and I have also tried hiding zero values in th
spreadsheet, but neither of these work. Please help

 

[Ron Coderre]

Try having your formula return an error instead of ""

Example:
=IF(A1>0,A1,NA())

Charts plot values, but not errors. Consequently, there will be no
plummeting line.

Does that help?

Regards,
Ron