CHART WITH TWO COLUMNS OR TWO ROWS

[TerryWood]

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

[Villeroy]

You'd like to get a graph, showing how "SUM" changes in time?
When asked for the data range, check "First Column As Label".

[billyboy]

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.
_________________
OOo-DEV 3.4 -Seamonkey, Firefox & Thunderbird trunk - Win Vista HB
==============================================
Creation
Answers

[TerryWood]

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