Charts for 2008 with No Values

T

TinleyParkILGal

David and Andy,
Thanks for your posts. Whether I use #N/A or =NA() I get the value 0 on my
chart and it is plotted so it looks like the value has gone down to zero. I
do not even want the line after November since we have not yet closed 12/2007.

The cell was originally formatted as a number and I tried number, general,
as well as text and nothing works. All return 0 and it is plotted with a line.

Thanks for your help.
 
T

TinleyParkILGal

Thank you all, Andy, David, Bob, Jon, for your replies.
What actually worked was Andy's suggestion to change the chart sub-type.
Andy had told me that the real problem was the chart type. I had used a
stacked line chart and it seems like we can get a chart that does not display
the nulls by using any line sub-chart other than stacked and by using N/A().

Thank you all for your help.
Happy and safe holidays to all.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non Linear Scatter plot, need to find y value 3
Scatter chart with categories on x-Axis 2
Plotting NA() or #N/A data points 1
Excel line chart not displaying correctly 1
scatter chart with gaps in series (XL 2007) 7
NA in Line chart plotting as zero 3
Charts for 2008 with No Values 6
Blank instead of "" 5

Top