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

Getting the date to appear on a chart axis

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


Joined: 05 Sep 2011
Posts: 3

PostPosted: Mon Sep 05, 2011 6:04 am    Post subject: Getting the date to appear on a chart axis Reply with quote

I have 2 columns of data that I wish to chart against each other. In Column A is a Date ie 01/09/2011 and in Column B a Value. I want to a line chart of Value (Y axis) against Date (X axis) with the date appearing along the x axis as 'September 2011' and not just the an integer showing which reading number it is. How do I change the x axis labelling?
Back to top
View user's profile Send private message AIM Address
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Sep 05, 2011 6:08 am    Post subject: Reply with quote

In a x/y-scatter type of chart both axes are numeric scales and they are freely formattable.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
BGT
Newbie
Newbie


Joined: 05 Sep 2011
Posts: 3

PostPosted: Mon Sep 05, 2011 6:10 am    Post subject: Reply with quote

But I do not understand how to do it.
Back to top
View user's profile Send private message AIM Address
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Sep 05, 2011 6:34 am    Post subject: Reply with quote

New chart: Create an x/y-scatter chart, double-click the chart, double-click the x-axis, set the number format.

Existing one: Double-click the chart, Right-Click>ChartType... x/y-scatter, double-click the x-axis, set the number format.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
BGT
Newbie
Newbie


Joined: 05 Sep 2011
Posts: 3

PostPosted: Mon Sep 05, 2011 7:13 am    Post subject: Reply with quote

Thanks, that has got me someway to what I want, but it is counter intuitive.
Back to top
View user's profile Send private message AIM Address
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