How did you fix your original problem?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"terri" wrote in message
...
Andy --

I figured out the problem but now have another -- I have a trend line in
the
chart and I'd like it to stop where my data does, but it's going to whole
length of the work days -- any way to fix this?

thanks.

"terri" wrote:

Andy --

I using an if with an NA -- so for the days I don't have data it's giving
me
an N/A -- so for example if it's the 5th -- and the data for the 6th will
be
is cell A6 - the formula I have is =if(abs(A6)0,a6,NA()) - so the cell
will
return a #N/A - but my chart is still picking it up and taking the line
down
to zero -- is there something in one of the chart options I'm supposed to
be
chosing that maybe isn't set?

Thanks for the help.

"Andy Pope" wrote:

Hi,

Try either #N/A or the formula =NA(). N/A is probably still being
treated as
text.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"terri" wrote in message
...
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.

.