If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Zero's
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 |
Thread Tools | |
Display Modes | |
|
|