OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Data labels only in chart, not on chart axes?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
ToVeR
OOo Advocate
OOo Advocate


Joined: 06 Oct 2004
Posts: 238
Location: Belgi� - Belgique - Belgien - Belgium

PostPosted: Thu Nov 11, 2004 1:47 am    Post subject: Data labels only in chart, not on chart axes? Reply with quote

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
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Thu Nov 11, 2004 6:45 am    Post subject: Re: Data labels only in chart, not on chart axes? Reply with quote

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
View user's profile Send private message
ToVeR
OOo Advocate
OOo Advocate


Joined: 06 Oct 2004
Posts: 238
Location: Belgi� - Belgique - Belgien - Belgium

PostPosted: Thu Nov 11, 2004 8:12 am    Post subject: Reply with quote

Quote:
Try this instead: http://www.padowan.dk


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 Wink , 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 Smile .
Back to top
View user's profile Send private message
ability
Power User
Power User


Joined: 02 Sep 2004
Posts: 79
Location: Bristol, UK

PostPosted: Sun Nov 14, 2004 1:42 pm    Post subject: XY chart Reply with quote

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
View user's profile Send private message
ToVeR
OOo Advocate
OOo Advocate


Joined: 06 Oct 2004
Posts: 238
Location: Belgi� - Belgique - Belgien - Belgium

PostPosted: Mon Nov 15, 2004 8:30 am    Post subject: Reply with quote

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
View user's profile Send private message
r_vinoya
Super User
Super User


Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines

PostPosted: Mon Nov 15, 2004 5:21 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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