If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2007 Chart with Zero Values
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. |
#2
|
|||
|
|||
Excel 2007 Chart with Zero Values
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. |
#3
|
|||
|
|||
Excel 2007 Chart with Zero Values
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. . |
#4
|
|||
|
|||
Excel 2007 Chart with Zero Values
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. . |
#5
|
|||
|
|||
Excel 2007 Chart with Zero Values
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. . |
#6
|
|||
|
|||
Excel 2007 Chart with Zero Values
It sounds like your original problem is exactly what I'm fighting with right
now. I get #N/A as a result of my check, but it still plots as zero. As for the trendline issue, if you right-click the trendline, and select "Format Trendline" it gives you an option for forecasting. Make sure this is set to 0 periods. "Andy Pope" wrote: 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. . . |
Thread Tools | |
Display Modes | |
|
|