Source Data

[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

 

[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

 

[osaka78]

yes it's as a result of formula , it does't work Zero is charted still