Ask Your Question

Secondary x-axis for different date range [closed]

asked 2014-11-16 19:42:52 +0200

deniscampbell gravatar image

updated 2014-11-16 19:43:43 +0200

I have two sets of monthly data, one for 2012 and the other for 2013. I would like to compare the two on a line or x-y chart using 2012 on the primary x-axis and 2013 on the secondary x-axis. How can this be achieved?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-06 04:04:06.311284

2 Answers

Sort by » oldest newest most voted

answered 2014-11-16 20:20:40 +0200

deniscampbell gravatar image

Answering my own question:

Line chart: Column A rows 1 thru 24 01jan12 to 01dec13. Column B rows 1 thru 12 enter data for 2012 only. Column C rows 13 thru 24 enter data for 2013 only. Add secondary x-axis by Insert>Axis> add tick to secondary x-axis. Format>Axis>X-Axis>Scale>type> date max and min for 2012 dates. Format secondary x-axis similarly for 2013 dates.

Set up Data Series y-values for col B 1 thru 12, and for col C 13 thru 24. Categories A1 through A24.

Just make sure the primary and secondary x-axes scales match up as regards the months.

Pretty obvious I suppose, but hope this helps someone like me - who has spent hours searching for the obvious!

edit flag offensive delete link more


I apologise if I have mislead anyone, but the method I described doesn't seem to work. It only appears to. The dates on the secondary x-axis are nothing other than labels. I tried plotting the chart as an xy scatter. That allows you to choose different x ranges for different y ranges, but the result is the same as the line chart. The secondary x-axis is just labels on the axis, and doesn't do anything. Could this be a bug or an oversight?

deniscampbell gravatar imagedeniscampbell ( 2015-11-30 16:05:30 +0200 )edit

Question Tools

1 follower


Asked: 2014-11-16 19:42:52 +0200

Seen: 2,135 times

Last updated: Nov 16 '14