[CentOS] (OT) OpenOffice.org calc chart strangeness.

Wed Apr 7 00:44:10 UTC 2010
Bill Campbell <centos at celestial.com>

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.

INTERNET:   bill at 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

A government which robs Peter to pay Paul can always depend on the support
of Paul -- George Bernard Shaw