Hi Wayne,
Wayne wrote:
On Mon, 2009-03-09 at 14:11 -0400, 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
P.S.
I just notice that my key on the chart is the data point i want to
graph. I did select the option "use first column for labels". This did
not work.
You should de-select the option 'use first column for labels'. What is
meant here is the first column in the selected range, so if you only
have one column all your data is used as labels only.
Kind regards,
Ingrid
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
