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

Scaling of the X-axis

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


Joined: 28 Mar 2006
Posts: 2

PostPosted: Tue Mar 28, 2006 3:44 pm    Post subject: Scaling of the X-axis Reply with quote

Way back in the day of version 1.4 or maybe earlier, I created a chart in OO
and it seemed to be an easy task, and came out very nicely. I haven't been
able to do this since.

The chart I am trying to make has dates on the X-axis and when using the
auto-format, the chart that is created places every date (perhaps several
hundred) at each data point. It does not 'scale'.

After long trial and error, I determined that on a chart I kept from the
(much) earlier version of OO has a tab in the X properties for 'scale' but
any chart made with the later versions does not. Without the SCALE tab, the
graphs are pretty useless.

Is there a way to get the SCALE tab to return to the X-axis as well as the
Y-axis?

Thanks.
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada

PostPosted: Wed Mar 29, 2006 5:02 am    Post subject: Re: Scaling of the X-axis Reply with quote

bmarsh wrote:
Way back in the day of version 1.4 or maybe earlier, I created a chart in OO
and it seemed to be an easy task, and came out very nicely. I haven't been
able to do this since.

The chart I am trying to make has dates on the X-axis and when using the
auto-format, the chart that is created places every date (perhaps several
hundred) at each data point. It does not 'scale'.

After long trial and error, I determined that on a chart I kept from the
(much) earlier version of OO has a tab in the X properties for 'scale' but
any chart made with the later versions does not. Without the SCALE tab, the
graphs are pretty useless.

Is there a way to get the SCALE tab to return to the X-axis as well as the
Y-axis?

Thanks.


You should be able to scale an XY graph with no problem just as you do a y-axis, that is, with a Scale tab when editing the x-axis. It sounds to me as if you have used the Line Chart option rather than the XY graph. This gives you an catagorical x-axis (analogous to a bar chart) and thus you cannot scale it.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
bmarsh
Newbie
Newbie


Joined: 28 Mar 2006
Posts: 2

PostPosted: Wed Mar 29, 2006 5:54 am    Post subject: Reply with quote

Well, you are right. If I pick an XY chart, the X axis has the SCALE tab. So I can't get X to scale with a line chart? Strange. My older chart *was* a line chart and the X axis has the scale tab. I'm still using the old file (in 2.0.2) and just modifying the data. A weird way to have to deal with the problem.
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada

PostPosted: Thu Mar 30, 2006 6:47 am    Post subject: Reply with quote

bmarsh wrote:
Well, you are right. If I pick an XY chart, the X axis has the SCALE tab. So I can't get X to scale with a line chart? Strange. My older chart *was* a line chart and the X axis has the scale tab. I'm still using the old file (in 2.0.2) and just modifying the data. A weird way to have to deal with the problem.


All I can think of is that the Chart funtions in Calc are a moving target and this must have changed. Logically you should not be able to scale the x-axis in a line chart since it is actually graphing numbers against categories. The chart does not know the difference between the catagories 1,2,3 and Man, Horse, Dog. It is hard to scale the latter categories Smile.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
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