Zero's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
GM
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(A1<>0, B1/A1, NA()) still display the values even if it shows as N/A.....please...HEL
 
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
 
Back
Top