Re: A plea from a semi-newbie



If you really want a line plot, you can ignore the time column. The
first column is used as labels and the second as the values.

Le vendredi 16 janvier 2015 à 15:08 -0700, rodgos a écrit :
Well, I do seem to be making some headay in this problem, albeit slowly..
So far, Ive created a Gnumeric spreadsheet populated with 3 column and 8928
lines of data. if I highlight all this, and click on 'Insert a chart', I get
a box, which at first makes no sense. I click on 'line', since I want a line
graph. . Select 'unmarked line plot', since I don't want markers. The the
first breakthrough. If I click on 'Use first series as shared absissa' and
the thing starts to make sense. The axes swing to place the data in column A
(date0, as the absissa, and columns B and C (time and temperature) as the
ordinate. Having, at last attained a logical structure I can go 'Forward'
and insert the chart into the spreadsheet.
Back to the spreadsheet I can now begin to organise the data, and the
appearance. I have a graph of the temperature against the date, which is
what I was after. With another of the time against the date, which is
irrelevant, and which I shall delete. The next bit is detail work to
regularise the scales  and overall values, set the colours, fonts titles and
labels. Then go on to add rainfall as a bar chart
I must have done this all before, but, over time, it must have been
forgotten. If thiss is anything to go by, it was probably forgotten with
some rlief. It does seem to be a very complicated and un-intuitive way to go
about things. If it had been a manually drawn graph, the setting up would
have taken just a few minutes.



--
View this message in context: 
http://gnome-apps.13852.n7.nabble.com/A-plea-from-a-semi-newbie-tp66352p66365.html
Sent from the GnuMeric mailing list archive at Nabble.com.
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]