| View previous topic :: View next topic |
| Author |
Message |
Le Murphy
General User
Joined: 12 May 2004
Posts: 9
Location: Nancy, France
|
 Posted: Thu Dec 09, 2004 1:58 pm Post subject: Graphs in Ooo Calc |
 |
|
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 |
|
 |
noglider
Newbie
Joined: 15 Dec 2004
Posts: 2
|
| Posted: Wed Dec 15, 2004 1:16 pm Post subject: |
|
|
| I hope Calc can make graphs, too. I couldn't figure out how. |
|
| Back to top |
|
|
egill
General User
Joined: 30 Nov 2004
Posts: 23
Location: Netherlands, Amsterdam
|
| Posted: Thu Dec 16, 2004 3:41 am Post subject: Graphs in OOo Calc |
|
|
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 |
|
|
r_vinoya
Super User
Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines
|
| Posted: Thu Dec 16, 2004 9:34 pm Post subject: |
|
|
Here is a screen shot of the type of charts you can do with OpenOffice.
_________________
# : - ) |
|
| Back to top |
|
|
afmoene
Newbie
Joined: 08 Sep 2004
Posts: 4
|
| Posted: Sat Dec 18, 2004 2:48 pm Post subject: graphs in Calc |
|
|
| 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 |
|
|
|
