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
Creating Network Diagram using a Chart SW integration 0
wanting to NOT plot #Div/0 on chart 1
Non Linear Scatter plot, need to find y value 3
Dynamic Charts with sub-groups? 0
Create a chart from a table in word thats dynamic 0
#N/A plotted as 0 on line chart 0

Top