Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Grouping Objects in a Chart or Graph | Excel Discussion (Misc queries) | |||
How to Name Chart Objects | Excel Discussion (Misc queries) | |||
Toggle Chart Series Objects On/Off | Charts and Charting in Excel | |||
Excel - let search for more than one disconnected word in a cell | Excel Worksheet Functions | |||
Why can't I resize/move objects in XL XP chart? | Excel Discussion (Misc queries) |