| View previous topic :: View next topic |
| Author |
Message |
steve4810
General User
Joined: 20 Feb 2012
Posts: 5
|
 Posted: Mon Feb 20, 2012 7:58 am Post subject: [SOLVED]how to divide X axis in to quarters on line chart |
 |
|
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 |
|
 |
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1875
Location: Sydney, Australia
|
| Posted: Mon Feb 20, 2012 2:05 pm Post subject: |
|
|
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 |
|
|
steve4810
General User
Joined: 20 Feb 2012
Posts: 5
|
| Posted: Mon Feb 20, 2012 2:13 pm Post subject: |
|
|
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 |
|
|
steve4810
General User
Joined: 20 Feb 2012
Posts: 5
|
| Posted: Mon Feb 20, 2012 2:32 pm Post subject: |
|
|
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 |
|
|
|
