[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
Engineer
Guest

 Posted: Mon Mar 15, 2004 3:19 pm    Post subject: Adding multiple series to a chart When using x-y 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
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.
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 x-y 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 x-value and Y1:Y10 as the y-value... Series 2 uses coordinate X21:X30 as the x-value and Y21:Y30 as the y-value...

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 x-coordinates with Y21:Y20 for y coordinates)

I hope someone can disprove Notes 1 and two above... (In excel there is no problem)

#:-)
_________________
# : - )
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 x-values (plotted against the single x-axis). You cannot have multiple x-axes.

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.
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 XY-charts 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 X-Y series will show up properly and can be formatted individually
imednev
Newbie

Joined: 12 Oct 2004
Posts: 2

 Posted: Tue Oct 12, 2004 10:49 am    Post subject: I have the same problem and decided to use Gnuplot for the plot part of my work with Openoffice. Some links for it: http://t16web.lanl.gov/Kawano/gnuplot/index-e.html http://sparky.rice.edu/~hartigan/gnuplot.html http://www.gnuplot.info/docs/gnuplot.html Ivan
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum