Zero's

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
 
J

Jon Peltier

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
 

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

One extra x axis item that wont go away - can anyone help? 3
Don't show zeros or #N/A in Column Chart 2
Show zero value but hide NA 3
Charting blanks as spaces 1
Custom Formatting a Chart Data Label 1
Chart to display zeroes values 1
OTHER options for chart not plotting null ("") or zero values 2
how do I setup a pie chart that does not plot zero values ? 1

Top