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?
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!
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?