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

CHART WITH TWO COLUMNS OR TWO ROWS

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


Joined: 24 Jul 2005
Posts: 8

PostPosted: Tue Dec 20, 2005 1:24 pm    Post subject: CHART WITH TWO COLUMNS OR TWO ROWS Reply with quote

I decided to try out my new installation of OO 2.0 Calc (Win XP SP2) English UK

Am very familiar with producing charts using EXCEL 97. BUT try as I might I cannot produce a simple line chart from either two columns or two rows. Details as Below:-

SUM DATE
1 21 Dec 2005
3 22 Dec 2005
7 23 Dec 2005
12 24 Dec 2005
9 25 Dec 2005
8 26 Dec 2005
11 27 Dec 2005
14 28 Dec 2005
And so on

1) Whatever configuration I use I cannot get a line to show that mirrors the numbers above
2) I cannot get the dates to show on the x Axis (Whatever changes I make, rational or irrational!!

Can somone put me right I have spent hours yet when I return to Excel I can do it in seconds?

PLEASE HELP

Thanks

Terry
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Dec 21, 2005 3:30 am    Post subject: Reply with quote

You'd like to get a graph, showing how "SUM" changes in time?
When asked for the data range, check "First Column As Label".
Back to top
View user's profile Send private message
billyboy
Super User
Super User


Joined: 08 Sep 2005
Posts: 504
Location: Belfast, Northern Ireland

PostPosted: Wed Dec 21, 2005 4:45 am    Post subject: Reply with quote

Terry
it is normal (conventional) to put the independent variable (date) on the x-axis (horizontal) and the dependent (effect) variable (sum) on the y-axis (vertical). In the spreadsheet this is normally achieved by assuming the first column to be the x-axis and the second to be y-axis.
Therefore your sum should be the second column and the date in the first.

HTH
Bill

edited: by the way, Villeroy's comments must still be applied. Very Happy
_________________
OOo-DEV 3.4 -Seamonkey, Firefox & Thunderbird trunk - Win Vista HB
==============================================
Creation
Answers
Back to top
View user's profile Send private message
TerryWood
General User
General User


Joined: 24 Jul 2005
Posts: 8

PostPosted: Wed Dec 21, 2005 7:03 am    Post subject: CANT GRAPH TWO COLUMNS Reply with quote

Thanks - absolutely spot on it works doing it this way round. Although I needed to tweak one or two settings. OO appears to be a litle more pedantic than Excel, but it now works.

Many thanks for all your help.

I have noticed one or two postings similar to mine perhaps your expnation ought to be in the help section of Calc for less knowledgeable people.

Terry
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