Is there any way to have a line chart ignore the zeros other than manipulate the formula to show NA?
H Homer Aug 11, 2009 #1 Is there any way to have a line chart ignore the zeros other than manipulate the formula to show NA?
J Jon Peltier Aug 11, 2009 #2 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
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 Aug 11, 2009 #3 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.
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.
