R Rlopez24 New Member Sep 4, 2012 #1 I have a array for my chart and since I am using a formula even though the it shows a blank it still inputs a 0 opn the chart. Is there anyway i can make it so it doesn't show the 0 on the chart when it should be blank?
I have a array for my chart and since I am using a formula even though the it shows a blank it still inputs a 0 opn the chart. Is there anyway i can make it so it doesn't show the 0 on the chart when it should be blank?
Luke M Excel Ninja Staff member Sep 4, 2012 #2 If you want your chart to skip a spot, try to have the formula evaluate to teh #N/A error. Something like: =IF(A2<0,NA(),A2) usually works.
If you want your chart to skip a spot, try to have the formula evaluate to teh #N/A error. Something like: =IF(A2<0,NA(),A2) usually works.
