Source Data

O

osaka78

Source Data
I have the following data
A B C D
1 1 2
2 2 3
3 3 6
4 0 0
5 0 0
Source Data is =Sheet1!$A$1:$b$5

When I am making the Chart I don’t wont 0 to be part of the chart and I
don’t want to change the Source data range

Can any one help with this
 
M

Mike H

Hi,

How is the zero derived? If it's as a result of a formula make the formula
return NA instead of zero and Excel won't chart it. Fir example

IF(C2=1,C2,NA())

Mike
 
D

David Biddulph

What formula are you using, and which data gives you a point charted as zeo?
NA() will not be charted as zero, so you need to look at what your formula
is generating.
 
Top