View previous topic :: View next topic 
Author 
Message 
Engineer Guest

Posted: Mon Mar 15, 2004 3:19 pm Post subject: Adding multiple series to a chart 


When using xy scatter graphs, how do I add multiple series to charts that have different “x” and “y” coordinates?
I understand how to add multiple lines with the same “x” coordinate, but what if the “x” coordinates vary as well?
Engineering Student 

Back to top 


dfrench Moderator
Joined: 03 Mar 2003 Posts: 1605 Location: Wellington, New Zealand

Posted: Tue Mar 16, 2004 2:42 pm Post subject: 


Not with the current version of OOo. Please search forum for similar posts. 

Back to top 


r_vinoya Super User
Joined: 03 Dec 2003 Posts: 619 Location: Somewhere in the Philippines

Posted: Thu Mar 18, 2004 10:09 pm Post subject: Re: Adding multiple series to a chart 


Engineer wrote:  When using xy scatter graphs, how do I add multiple series to charts that have different “x” and “y” coordinates?
I understand how to add multiple lines with the same “x” coordinate, but what if the “x” coordinates vary as well?
Engineering Student 
If I understand correctly... I have the same problem with yours before.
I just found the solution myself by accident...
1) Right Click on your chart... then select "Modify Data Range"
2) On the Range type something like this: $currentsheet.$X$1:$Y$10; $currentsheet.$X$21:$Y$30;
3) Click CREATE button.
The procedure above produces two series data: Series 1 uses coordinate X1:X10 as the xvalue and Y1:Y10 as the yvalue... Series 2 uses coordinate X21:X30 as the xvalue and Y21:Y30 as the yvalue...
Note:
There are some rules that I discovered in making charts:
1) You cannot create chart for reference values located in another sheet.
2) The x and y coordinates must be "Parallel" (can't use X1:X10 for xcoordinates with Y21:Y20 for y coordinates)
I hope someone can disprove Notes 1 and two above... (In excel there is no problem)
#:) _________________ # :  ) 

Back to top 


dfrench Moderator
Joined: 03 Mar 2003 Posts: 1605 Location: Wellington, New Zealand

Posted: Thu Mar 18, 2004 10:59 pm Post subject: 


see http://www.oooforum.org/forum/viewtopic.php?t=4401&highlight=chart
The situation appears unchanged at 1.1.1Rc.
Yes, you can supply a lot of ranges but the first column of each range contributes to a single domain of xvalues (plotted against the single xaxis). You cannot have multiple xaxes.
In the example provided by r_vinoya above, I would expect a single series to be plotted. Regardless of the number of ranges, if the ranges have the same number of columns the effect is concatenating the sets of values.
This is certainly the effect that I see here.
Quote:  You cannot create chart for reference values located in another sheet. 
You certainly can have a chart on one sheet that has a range or ranges from another sheet. one of the options on creating the chart is to specify where it is placed
Note 2 is certainly true though. The set of cell ranges comprising the 'data range' for the chart describe the x and y values together , there is no means to define a series of values independently within the underlying object model. 

Back to top 


ftack Moderator
Joined: 27 Jan 2003 Posts: 3102 Location: Belgium

Posted: Sat Mar 20, 2004 8:03 am Post subject: 


Anyway, someone posted here a wonderfull workaround to create XYcharts with different XY ranges. I did not found the thread back, but here is how it goes. Just enter your data like this
X Y1 Y2 Y3
x11 y11
x12 y12
x13 y13
x21 y21
x22 y22
x23 y23
x31 y31
x32 y32
x33 y33
Plot the data and the different XY series will show up properly and can be formatted individually 

Back to top 


imednev Newbie
Joined: 12 Oct 2004 Posts: 2


Back to top 


