I have a mysql database that structured with date, time and reading. I have been looking for something that would produce a graph of these values. Gnumeric is supposed to be able to do this, but there is nothing in the menu that allows it.
I checked the plugins and the "Charting" plugins are all selected, but I can't see a way to produce charts.
# l /usr/lib64/goffice/0.4.2/plugins/
total 44
drwxr-xr-x 11 root root 4096 2007-08-20 20:02 ./
drwxr-xr-x 3 root root 4096 2007-08-20 20:02 ../
drwxr-xr-x 2 root root 4096 2007-08-27 01:14 plot_barcol/
drwxr-xr-x 2 root root 4096 2007-08-27 01:14 plot_boxes/
drwxr-xr-x 2 root root 4096 2007-08-27 01:14 plot_pie/
drwxr-xr-x 2 root root 4096 2007-08-27 01:14 plot_radar/
drwxr-xr-x 2 root root 4096 2007-08-27 01:14 plot_surface/
drwxr-xr-x 2 root root 4096 2007-08-27 01:14 plot_xy/
drwxr-xr-x 2 root root 4096 2007-08-27 01:14 reg_linear/
drwxr-xr-x 2 root root 4096 2007-08-27 01:14 reg_logfit/
drwxr-xr-x 2 root root 4096 2007-08-27 01:14 smoothing/
Tried graph, plot, some stuff from graphviz and a few others, but no luck. The database has been exported as .csv, .ods, .xml, .pdf and .sql.
Any ideas? Thanks.

The way I would go about it is to import the csv file in to OpenOffice Calc, select the data to graph, and then tell it to make a chart out of it. It seems like extra work to try and get a program to turn the csv into a graph without going into a spreadsheet format first.

Looked again at gnumeric and I can produce a chart from the .ods file, just have to get to grips with saving and printing it.

Thanks, I shall have a look at OOo again with the .csv and perhaps the .ods. I've been looking for days. The chart I produced with gnumeric I did by trial and error, nothing was really obvious, tried one thing and then another, hit "Insert", nothing happened, then clicked somwhere and up popped the chart.
BTW, I've just tried the .ods in OOo and that does the business also.

OOo Calc only imports 43 entries of the .csv file which currently has 64 entries.