The NA() or #N/A only prevents plotting of a marker (in an XY, line, or
radar chart). Otherwise it is plotted as a bar of zero thickness, either on
the category axis or in its place in the order of stacked series. It is not
really a value of zero, as a text entry would be; if the category axis
crosses at a Y value other than zero (bad practice for a bar or column
chart, by the way), the Excel-interpreted zero value of the text will result
in a bar or column from the category axis to zero on the Value axis. The
#N/A does not result in such a zero-seeking bar.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"mac" wrote in message
...
I need some help with the problem. I tried this in my formula which is
=IF(V7+W70,V7+W7,NA()). This does not work for my bar chart. The chart
still
shoes my value as Zero. Why is that?
Mac

"Jon Peltier" wrote:

Since worksheets don't cost much, I generally make one table for each use
I
have for the data, all linked back to the original data. There could be
several sheets: one for the original data, one for the chart source data,
one for optimal screen viewing, one (or more) optimized to print, one or
more optimized to export to Word or PowerPoint. The chart one shows the
#N/A, and it's useful to show these; the ones for display do not. The
ones
for display might skip rows or columns and have fancy borders or shading
to
make them easy to read, the one for the chart does not. It's just so much
easier to do each table individually than to try to figure out how the
same
table will work for different functions that have different requirements.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jobe" wrote in message
...
Thank you guys for your input, NA() does work for not plotting zero
values
but now my table is is littered with #N/As. Is it possible to have a
to
eliminate this display of the #N/As from the table. Otherwise I will
make
a
hidden table with NA().

"Bernard Liengme" wrote:

Agreed! so use NA() in place of "" in the formula
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Jon Peltier" wrote in message
...
If the "blank" is the result of "" in a formula, Tools menu
Options
Chart tab 'Plot Empty Cells As' will have no effect.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Bernard Liengme" wrote in message
...
Replace the blank cell by =NA()
or
With chart select: Tools | Options |Chart and specify how missing
data
is
to be treated
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Jobe" wrote in message
...
I can not figure out how not to plot data that referances blank
cells
as
zero's. I have a worksheet that links to tables with data
orginized
by
size
(mm) from big to small. This worksheet contains a scatter plot
graph
that
looks at all sizes in the table. Typically not all sizes have
data.
The
only way I can figure out to remove the zero values from the blank
cells
is
by manualy selecting these cells and clearing the content. I have
tried
several attempts at differant logic ( if(isnumber(A1),A1,""), and
if(isblank(A1),"",A1) ect. and nothing seems to work. I could use
conditional formating but I would like to keep things as simple as
possible