I have chart data for sales that I add to each day.

I hide the lines for the days to come(ie if it's the 5th, I hide lines for
the 6th - 31st) so that the chart doesn't go all the way down to zero for the
6th thru the 31st.

I'd like to be able to leave all lines unhid, but not have the chart line go
down to zero.

I've tried putting N/As in those days that I don't have data, but the chart
is still going to down to zero - I don't know if I have a setting wrong or
what, but any help would be much appreciated.

Thanks.