Not plot zero on line chart without using NA?

H

Homer

Is there any way to have a line chart ignore the zeros other than manipulate
the formula to show NA?
 
J

Jon Peltier

If there were, would we settle for using NA()? We've been asking for
something better for several versions of Excel.

There are two options: use NA() in the formula, or delete the formula
altogether.

- Jon
 
H

Homer

That's what I thought, but I figured I'd take a shot at someone having a
slick work around. I guess NA is the slick work around.

Sounds like Microsoft is as reseptive to changing the headaches as Autodesk
is.

Thanks for the help.
 

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

Impossible? Not plotting NA()s 2
Show zero value but hide NA 3
Don't show zeros or #N/A in Column Chart 2
error value in axis 1
Bar chart with no zero columns 4
Don't plot non-numeric cells 2
scatter chart with gaps in series (XL 2007) 7
Empty strings appear as zeros 4

Top