OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Adding multiple series to a chart

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Engineer
Guest





PostPosted: Mon Mar 15, 2004 3:19 pm    Post subject: Adding multiple series to a chart Reply with quote

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
Back to top
dfrench
Moderator
Moderator


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

PostPosted: Tue Mar 16, 2004 2:42 pm    Post subject: Reply with quote

Not with the current version of OOo. Please search forum for similar posts.
Back to top
View user's profile Send private message
r_vinoya
Super User
Super User


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

PostPosted: Thu Mar 18, 2004 10:09 pm    Post subject: Re: Adding multiple series to a chart Reply with quote

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)

#:-)
_________________
# : - )
Back to top
View user's profile Send private message
dfrench
Moderator
Moderator


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

PostPosted: Thu Mar 18, 2004 10:59 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Sat Mar 20, 2004 8:03 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
imednev
Newbie
Newbie


Joined: 12 Oct 2004
Posts: 2

PostPosted: Tue Oct 12, 2004 10:49 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group