XY Scattergram: Formatting lines crossing gaps in dataseries.

[StuHarder]

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

Bob,
(Sorry I had to start a new post. I was unable to reply using the previous list.)

Thank you for your efforts. I've had folks try your suggestion using the NA() substitute for "". The change solved one problem: empty cells in the data series were being plotted on the baseline (x-axis) of the chart and are not now. This is good. Zero is not defined on a log scale and should be treated as gaps in the data series. Now, however, all gaps are crossed by connecting lines. This is not correct. They should be left as gaps. If it is possible to send you a few screen shots, it will be easier to illustrate the problem.

Stu

 

[Carl Witthoft]

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

Bob,
(Sorry I had to start a new post. I was unable to reply using the previous
list.)

Thank you for your efforts. I've had folks try your suggestion using the NA()
substitute for "". The change solved one problem: empty cells in the data
series were being plotted on the baseline (x-axis) of the chart and are not
now. This is good. Zero is not defined on a log scale and should be treated
as gaps in the data series. Now, however, all gaps are crossed by connecting
lines. This is not correct. They should be left as gaps. If it is possible to
send you a few screen shots, it will be easier to illustrate the problem.

Stu

You're stuck with it. The connecting lines will be drawn unless the
cells are empty, i.e. fully Clear-ed. This is not the same as entering
"" or even deleting the existing contents.
Stupid bug in Excel that's been there forever. (I even wrote a macro
once to Clear cells based on criteria like yours, but that was ugly)
In all honesty, you may want to play with gnuplot or R for better
graphing capabilities.