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

[SOLVED]how to divide X axis in to quarters on line chart

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


Joined: 20 Feb 2012
Posts: 5

PostPosted: Mon Feb 20, 2012 7:58 am    Post subject: [SOLVED]how to divide X axis in to quarters on line chart Reply with quote

Y is dollars. X is day of the year. I want to draw three vertical lines marking 3/31, 6/30, 9/30. The primary X is a day of the year(column A) and secondary X is quarter (column B).
Column B only has a value entered on quarterly dates ie: 0,1,2,3,4 entered on 12/31, 3/31, 6/30, 9/30, 12/31. I've gotten the secondary X to display the 0,1,2,3,4 but can't get a dividing line drawn up the chart on those days. The secondary X axis "format axis" shows the "scale" tab with grayed out unchangeable values.

Thanks
_________________
Steve


Last edited by steve4810 on Mon Feb 20, 2012 2:30 pm; edited 1 time in total
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Mon Feb 20, 2012 2:05 pm    Post subject: Reply with quote

Perhaps you should be using the X-Y (Scatter) chart type where you have much greater control over what is displayed.
See attached doc (Delineated Quarters.ods)...
http://www.mediafire.com/view/?4jpl3xh5tc158vx
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).


Last edited by ken johnson on Wed Sep 26, 2012 8:19 pm; edited 1 time in total
Back to top
View user's profile Send private message
steve4810
General User
General User


Joined: 20 Feb 2012
Posts: 5

PostPosted: Mon Feb 20, 2012 2:13 pm    Post subject: Reply with quote

ken johnson wrote:
Perhaps you should be using the X-Y (Scatter) chart type where you have much greater control over what is displayed.
See attached doc...
http://www.4shared.com/file/MgobHzzh/Delineated_Quarters.html
Ken Johnson
Thanks. I'll change the title to solved as soon as I figure out your example. At first glance it seems to do exactly what I want.
_________________
Steve
Back to top
View user's profile Send private message
steve4810
General User
General User


Joined: 20 Feb 2012
Posts: 5

PostPosted: Mon Feb 20, 2012 2:32 pm    Post subject: Reply with quote

OK, got it going but it's going to be a while until understand it completely. So far I just pasted my data into the example and adjusted the scales. But I'm on the way.
_________________
Steve
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