On Mon, 2009-03-09 at 11:24 -0700, JOE Conner wrote: > Wayne wrote: > >>>> Hi, > >>>> i have oo 3.01 installed on ubuntu release 8.0 on linux. > >>>> i'm trying too create a chart where i select the data points > >>>> to use. for example i would like to select the point B4, B9, and B34. > >>>> How should I enter these point in the data range field. > >>>> I did something like this, but did not work - > >>>> $Sheet1.$B$4:$B$9:$B$34 > >>>> Second question. Is there a book on oo 3 that would cover this > >>>> type of question? > >>>> Wayne > >>>> > >>>> > >>> The method I would use: Create two new contiguous colums. 1. A new > >>> column and put the x axis data points on it. > >>> 2, A new column with the Y axis data points corresponding the the X axis > >>> data points. These could actually be on a second worksheet if desired. > >>> Use these new columns to create your graph (use type X-Y). > >>> > >>> Joe Conner, Poulsbo, WA USA > >>> > >> Thanks Joe, > >> I figured out my problem. The command would look something like this. > >> $Sheet1.$B$4;$Sheet1.$B$9;$Sheet1.$B$34 > >> > > > > I thought I had my problem solved, BUT I add more data point, about 10 > > more, I get the key in the chart, but no graph. What gives? > > Wayne > > > > > > > > > This is not a problem using my method. > Joe Conner, Poulsbo, WA USA
Joe, I'm not saying your solution is a problem. I appreciated your help. Wayne It seems that the values I put in for Data Range are being used for Data Series. I don't know how to solve this. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
