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

Graphs in Ooo Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Le Murphy
General User
General User


Joined: 12 May 2004
Posts: 9
Location: Nancy, France

PostPosted: Thu Dec 09, 2004 1:58 pm    Post subject: Graphs in Ooo Calc Reply with quote

Hello,

I'm trying to put in a same graph several datas which stand in different rooms of my calc sheet. I would like to build it in a XY plan.
(1 abscissa and several series of datas based on this abscissa)
I would like to leave MS Excel but if I can't create graphs as I want I won't be able to use Ooo Calc.

Could anybody help me ?

Thank you for your answer
_________________
A french user of Openoffice
Back to top
View user's profile Send private message Send e-mail
noglider
Newbie
Newbie


Joined: 15 Dec 2004
Posts: 2

PostPosted: Wed Dec 15, 2004 1:16 pm    Post subject: Reply with quote

I hope Calc can make graphs, too. I couldn't figure out how.
Back to top
View user's profile Send private message
egill
General User
General User


Joined: 30 Nov 2004
Posts: 23
Location: Netherlands, Amsterdam

PostPosted: Thu Dec 16, 2004 3:41 am    Post subject: Graphs in OOo Calc Reply with quote

Hi,
You can make graphs in OOo Calc. Select the data that you want to put in a chart and select Insert Chart in the Insert menu OR you go to the icon in the Main Toolbar on the right of your screen. Now you get a chart wizard that allows you to make a chart. If you need to change data in a chart, click on the chart and see the anker icon appear, rightclick and there are change possibilities.
I hope this information was useful,
Cheers
EVA
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 Dec 16, 2004 9:34 pm    Post subject: Reply with quote

Here is a screen shot of the type of charts you can do with OpenOffice.

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


Joined: 08 Sep 2004
Posts: 4

PostPosted: Sat Dec 18, 2004 2:48 pm    Post subject: graphs in Calc Reply with quote

r_vinoya wrote:
Here is a screen shot of the type of charts you can do with OpenOffice.


Yes, sure, that is the wizard. But making a graph from series that are not in adjacent colums is a pain. And worse: try add a series after having created the grap. And it is -as far as I know- impossible to have a series with a different x-column in one graph:

series 1: x = a1:a20 ; y = g1:g20
series 2: x = c3:c120 ; y = z3:c120

Really, the data-series interface of calc is a bad. And as far I have seen, no update is planned for 2.0. I nearly use all of OpenOffice, but for the spreadsheet I always go to either Gnumeric, or Excel (through VMware). It's a pity.

Cheers, Arnold[/b]
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