Scattergram: Format Data Series w/ Gaps

[StuHarder]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I use a formula =if(cell=0,"",cell value) in order to create gaps in my data series plotted on a log-linear scattergram. I do not want the data points that bracket these gaps to be connected by lines; I want gaps to show up as gaps. How do I format the series to do this? Can I do it globally for all scattergrams?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I use a formula =if(cell=0,"",cell value) in order to create gaps in my data
series plotted on a log-linear scattergram. I do not want the data points that
bracket these gaps to be connected by lines; I want gaps to show up as gaps.
How do I format the series to do this? Can I do it globally for all
scattergrams?

The line appears because Excel thinks the "" should be plotted as zero. F
you want breaks in the lines, use NA instead of "". So, the formula should
be something like: =if(cell=0,na(),cell value)

And didn't I just answer this? In another thread, maybe.

 

[StuHarder]

And didn't I just answer this? In another thread, maybe.

Bob,
Thanks for your response. The only other post I've located refers to data point labels. I am referring to the formatting of a chart series in which lines connect contiguous data points but does not connect points with missing data in between. I can do this Excel 2007 (Windows Vista), but am having trouble finding the equivalent means for MacOS.
Thanks.
Stuart Harder

 

[Bob Greenblatt]

Bob,
Thanks for your response. The only other post I've located refers to data
point labels. I am referring to the formatting of a chart series in which
lines connect contiguous data points but does not connect points with missing
data in between. I can do this Excel 2007 (Windows Vista), but am having
trouble finding the equivalent means for MacOS.
Thanks.
Stuart Harder

Did my answer not work?