I am attempting to create a simple line chart graphing three columns from a soffice-calc spreadsheet. I expect it to take the leftmost column as the X-Axis, plotting the others on the Y-Axis, but it always creates an X-Axis of the row number in the columns, and the first column amongst the data.
I have tried this on OpenOffice.org 3.2.0, NeoOffice(R) 3.0.2 Patch 2, iWork Pages, and Excel 12.2.4 in Microsoft Office 2008 for Mac.
It does what I expect in iWork Pages and M$-Excel, but not in the various incantations of OpenOffice.org.
I OO-calc has gone to a fancy wizard thingy that doesn't seem to have any way to specify details for the X-Axis, and I can't find anything useful in the on-line documentation.
Does anybody know how one gets this to work in OpenOffice.org?
The Linux tie-in is that I'm getting data from a postgresql database that lives on a Linux box, and none of the fancy commercial products seem to be able to use it in their data sources.
On the other hand, I have written a python script that extracts the data from the postgresql database and creates the pretty reports using groff and gplot totally on Linux which is faster in any case for my current problem.
Bill
Le 2010-04-02 à 20:19, Bill Campbell a écrit :
I am attempting to create a simple line chart graphing three columns from a soffice-calc spreadsheet. I expect it to take the leftmost column as the X-Axis, plotting the others on the Y-Axis, but it always creates an X-Axis of the row number in the columns, and the first column amongst the data.
I have tried this on OpenOffice.org 3.2.0, NeoOffice(R) 3.0.2 Patch 2, iWork Pages, and Excel 12.2.4 in Microsoft Office 2008 for Mac.
It does what I expect in iWork Pages and M$-Excel, but not in the various incantations of OpenOffice.org.
I OO-calc has gone to a fancy wizard thingy that doesn't seem to have any way to specify details for the X-Axis, and I can't find anything useful in the on-line documentation.
Does anybody know how one gets this to work in OpenOffice.org?
The Linux tie-in is that I'm getting data from a postgresql database that lives on a Linux box, and none of the fancy commercial products seem to be able to use it in their data sources.
You should be able to connect to it with a ODBC driver for pgsql, Excel on both Windows and OS X should be able to talk to it by ODBC.
On the other hand, I have written a python script that extracts the data from the postgresql database and creates the pretty reports using groff and gplot totally on Linux which is faster in any case for my current problem.
Bill
INTERNET: bill@celestial.com Bill Campbell; Celestial Software LLC URL: http://www.celestial.com/ PO Box 820; 6641 E. Mercer Way Voice: (206) 236-1676 Mercer Island, WA 98040-0820 Fax: (206) 232-9186 Skype: jwccsllc (206) 855-5792
Blessed are the young, for they shall inherit the national debt. -- Herbert Hoover _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On Sat, Apr 03, 2010, Pascal Robert wrote:
Le 2010-04-02 à 20:19, Bill Campbell a écrit :
...
The Linux tie-in is that I'm getting data from a postgresql database that lives on a Linux box, and none of the fancy commercial products seem to be able to use it in their data sources.
You should be able to connect to it with a ODBC driver for pgsql, Excel on both Windows and OS X should be able to talk to it by ODBC.
Connecting OpenOffice.org/NeoOffice to postgresql isn't a problem using the JDBC drivers (which seems to be the logical choice given the Java heritage of StarOffice->OpenOffice.org. I have been connecting them to postgresql and mysql for year now.
My problem is that OO/NeoOffice charts don't seem to take the first column of data as the X-Axis, but put everything on the Y-Axis which doesn't make sense to me.
Bill
On Sun, 2010-04-04 at 20:16 -0700, Bill Campbell wrote:
My problem is that OO/NeoOffice charts don't seem to take the first column of data as the X-Axis, but put everything on the Y-Axis which doesn't make sense to me.
Bill
--- Look at the top row and Click on Chart (the icon). Then chart wizard will pop up, click number four (4). Default is set to Y axis. Also I have a like a Excel made sheet that only excel will do but the ability to do it in OO is not there but it still functions the same as exel when ran in OO. Odd it is.
John
On Mon, Apr 05, 2010, JohnS wrote:
On Sun, 2010-04-04 at 20:16 -0700, Bill Campbell wrote:
My problem is that OO/NeoOffice charts don't seem to take the first column of data as the X-Axis, but put everything on the Y-Axis which doesn't make sense to me.
Look at the top row and Click on Chart (the icon). Then chart wizard will pop up, click number four (4). Default is set to Y axis. Also I have a like a Excel made sheet that only excel will do but the ability to do it in OO is not there but it still functions the same as exel when ran in OO. Odd it is.
I think I finally figured this out after much trial and error. After selecting multiple columns and cliking on the chart icon, the trick is to select number 2. Data Range in the left column, then click on the ``First column as label'' to get it to use the first column as the X-Axis values.
To me this is not intuitively obvious.
Many thanks to those who contributed to this thread.
Bill
Bill Campbell wrote:
I am attempting to create a simple line chart graphing three columns from a soffice-calc spreadsheet. I expect it to take the leftmost column as the X-Axis, plotting the others on the Y-Axis, but it always creates an X-Axis of the row number in the columns, and the first column amongst the data.
I have tried this on OpenOffice.org 3.2.0, NeoOffice(R) 3.0.2 Patch 2, iWork Pages, and Excel 12.2.4 in Microsoft Office 2008 for Mac.
It does what I expect in iWork Pages and M$-Excel, but not in the various incantations of OpenOffice.org.
I OO-calc has gone to a fancy wizard thingy that doesn't seem to have any way to specify details for the X-Axis, and I can't find anything useful in the on-line documentation.
Does anybody know how one gets this to work in OpenOffice.org?
The Linux tie-in is that I'm getting data from a postgresql database that lives on a Linux box, and none of the fancy commercial products seem to be able to use it in their data sources.
On the other hand, I have written a python script that extracts the data from the postgresql database and creates the pretty reports using groff and gplot totally on Linux which is faster in any case for my current problem.
Bill
Hi Bill,
Don't know if this will help, hope it does. One thing that comes to mind is this sounds like a data series issues. It sounds like everything is included within the data series range. The only thing that should be in this, which would be the Y axis, is the 2nd and 3rd columns of data. I hope this helps in some way.
Lee
-
Bill Campbell -
JohnS -
Lee Perez -
Pascal Robert