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 -- 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