Line Chart , Plot zero values as blank

[Paddy1979]

Hello All,

Line Charts:

Is it possible to plot zero values as blank so there is no line on the chart for that value??

I tried if(a1=0,"",a1) but the graph still dispays a line across but with no series for that week with the zero sales.

Cheers
Paddy

 

[Oaktree]

You mean break the line/leave a gap?

Try:

http://www.andypope.info/charts/brokenlines.htm

 

[Paddy1979]

thanks thats what i'm after