| View previous topic :: View next topic |
| Author |
Message |
ToVeR
OOo Advocate
Joined: 06 Oct 2004
Posts: 238
Location: Belgi� - Belgique - Belgien - Belgium
|
 Posted: Thu Nov 11, 2004 1:47 am Post subject: Data labels only in chart, not on chart axes? |
 |
|
I have a data series, existing out of data in three colums, the first column contains text, the other two contains numerical data.
So, it is something like this (used code to get it to look right in the post):
| Code: |
1 2 3
TEXT 123 456
TEXT 123 456
TEXT 123 456
|
I would like to generate a chart that has the data of column 2 on the X-axis,
the data of column 3 on the Y-axis,
and the text data in column 1 as a label to the points in the graph.
Is there any way to achieve this? What type of chart is best used, what actions are needed, ... ? |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Thu Nov 11, 2004 6:45 am Post subject: Re: Data labels only in chart, not on chart axes? |
|
|
| ToVeR wrote: | I have a data series, existing out of data in three colums, the first column contains text, the other two contains numerical data.
So, it is something like this (used code to get it to look right in the post):
| Code: |
1 2 3
TEXT 123 456
TEXT 123 456
TEXT 123 456
|
I would like to generate a chart that has the data of column 2 on the X-axis,
the data of column 3 on the Y-axis,
and the text data in column 1 as a label to the points in the graph.
Is there any way to achieve this? What type of chart is best used, what actions are needed, ... ? |
Try this instead: http://www.padowan.dk
There are other math graphing programs aroundworth a llook as well.
David. |
|
| Back to top |
|
|
ToVeR
OOo Advocate
Joined: 06 Oct 2004
Posts: 238
Location: Belgi� - Belgique - Belgien - Belgium
|
| Posted: Thu Nov 11, 2004 8:12 am Post subject: |
|
|
I'll give it a shot when I get some free time during to get acquainted with the program.
Still, I do understand the crew behind OOo is not capable to provide in all features one possibly needs (as usual, a user wrongfully expects all his/her needs to be met  , and I do not expect them to do so, after all, it remains open-source and all that, but it is still a pity such a thing does not exist.
But I'll live through it  . |
|
| Back to top |
|
|
ability
Power User
Joined: 02 Sep 2004
Posts: 79
Location: Bristol, UK
|
| Posted: Sun Nov 14, 2004 1:42 pm Post subject: XY chart |
|
|
| Unless I'm missing something this looks like an XY chart. Select all the data, use the AutoPilot to create an XY chart and then choose Insert->Data Labels, Label Text. |
|
| Back to top |
|
|
ToVeR
OOo Advocate
Joined: 06 Oct 2004
Posts: 238
Location: Belgi� - Belgique - Belgien - Belgium
|
| Posted: Mon Nov 15, 2004 8:30 am Post subject: |
|
|
The most logical thing is that it would be an XY-chart, but, and I haven't got a clue why, my data just won't get itself set into in XY-chart.
Even if I only work with two data colums, one for the X-axis and one for the Y-axis, I get nothing in my chart, just an empty one. I do not know what is wrong with this feature, but XY-charts do not seem to function properly. |
|
| Back to top |
|
|
r_vinoya
Super User
Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines
|
| Posted: Mon Nov 15, 2004 5:21 pm Post subject: |
|
|
| ToVeR wrote: | The most logical thing is that it would be an XY-chart, but, and I haven't got a clue why, my data just won't get itself set into in XY-chart.
Even if I only work with two data colums, one for the X-axis and one for the Y-axis, I get nothing in my chart, just an empty one. I do not know what is wrong with this feature, but XY-charts do not seem to function properly. |
If you used the data described in your first post, the plot of x-y is just a dot (maybe you missed it).
Or maybe you haver included the TEXT part in the data range. Here the X-axis range is set as text. I don't know if the "First Column/Row As Label" works with xy charts (I can't make it work... But I can do it only using Line Charts)
_________________
# : - ) |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
