K
Ken Rogers
Consider the following:
A B
1 15 15
2 25 15
3 25 35
4 15 35
5 15 15
6
7 45 45
8 75 45
9 75 105
10 45 105
11 45 45
In Excel with row 6 present & blank you get two disconnected boxes
using XY-scatter format with lines and points. If you remove the empty
row 6 you get the boxes plus a line connecting points 15,15 and 45,45.
In Open Office Calc (OOC), you get the boxes connected in either case
unless you move one of the y sets to column B (creating two series.)
Although this is an Excel group, since I haven't been able to get any
response on the OOC forum I was hoping someone here might help. Is it
possible to make an OOC plot, with only one series, like the first
case above (boxes disconnected?)
If anyone does know I would greatly appreciate being told how to do
it.
Thanks, Ken Rogers
A B
1 15 15
2 25 15
3 25 35
4 15 35
5 15 15
6
7 45 45
8 75 45
9 75 105
10 45 105
11 45 45
In Excel with row 6 present & blank you get two disconnected boxes
using XY-scatter format with lines and points. If you remove the empty
row 6 you get the boxes plus a line connecting points 15,15 and 45,45.
In Open Office Calc (OOC), you get the boxes connected in either case
unless you move one of the y sets to column B (creating two series.)
Although this is an Excel group, since I haven't been able to get any
response on the OOC forum I was hoping someone here might help. Is it
possible to make an OOC plot, with only one series, like the first
case above (boxes disconnected?)
If anyone does know I would greatly appreciate being told how to do
it.
Thanks, Ken Rogers