Zero's

Hi Chris
maybe this could help you
http://andypope.info/charts/piezeros.htm

Frank

Chris wrote:
I am trying to build a chart based off of 2 columns, both utilizing
Vlookups. One column displays the category, the other the value.
Note these values will change:

Ford 2
GM 4
Chevy -

How can I build a chart that wont display a null value. Have tried
the tools/options/chart.....no good. have tried the =IF(A10,
B1/A1, NA()) still display the values even if it shows as
N/A.....please...HELP

Chris -

What type of chart is it? All our sage advice breaks down in an Area
chart, for instance: N/A is plotted as a null in an Area chart. And if
you're using data labels, the #N/A label shows up in area and pie
charts. In column and bar charts, the #N/A label also shows up, but not
where the point would go if it weren't an error; it shows up on top of
the label for the previous point.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Chris wrote:

I am trying to build a chart based off of 2 columns, both utilizing Vlookups. One column displays the category, the other the value. Note these values will change:

Ford 2
GM 4
Chevy -

How can I build a chart that wont display a null value. Have tried the tools/options/chart.....no good. have tried the =IF(A10, B1/A1, NA()) still display the values even if it shows as N/A.....please...HELP