Thanks for the reply, but I don't think that it will help. My problem is two fold. First, I require the x axis to be determined from the data in two columns. This is of a date and time nature. The total time for the graph, is one calendar month, where column A contains data as to the date, in the format of DD/MM/YYYY. Column B contains data as to time, in the format HH:MM:SS. Each row contains data of elapsed time at intervals of 5 minutes, giving a number of rows in the region of 9000, odd. It is no good working out a number to represent the number of seconds (the smallest time unit) since the X axis label has to be in the format DD/MM/YY. The Y axis is to display temperature, in the range 0 to100 DegF If I highlight all the data and create a (line) graph, it merely creates a graph with the X axis as date, from 1890 to 2020!!, tagged every 10 years, and a Y axis, consisting only of row numbers. Originally, some five years or so back, I had all this worked out. Unfortunately following a major disk crash, I lost all the data, both raw and in spreadsheet form, but fortunately the hard copy, which was the end product is intact, but since it is paper, I cannot interrogate it to ascertain, now, how I did it. My only recollection, is that in Gnumeric, it was quite simple. As I recollect, as soon as I had a working system I saved a version without date as a template, which alas is no more. In addition, the graph also indicated rainfall, as a bar chart, scaled to fit in with the temperature range. Since this data had to be entered manually, it was the greater chore. So the left hand X axis indicator registered the temperature, and another, to the right indicated rainfall.
-- View this message in context: http://gnome-apps.13852.n7.nabble.com/A-plea-from-a-semi-newbie-tp66352p66358.html Sent from the GnuMeric mailing list archive at Nabble.com. _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list
