I have a chart with multiple data series, all using the same column of dates
for the horizontal axis. I want to set some of the series to a secondary
vertical and horizontal axis, so I can time-shift the data in these series on
the graph. However, when I put these series on a secondary axis, the
secondary horizontal axis does not provide the same options as the primary
axis (which is derived from the exact same data).

For the primary axis, under "Format Axis - Axis Options" I am able to
select a minimum, maximum, major unit, minor unit, a dropdown of
days/months/years, etc. But for the secondary axis, under "Format Axis -
Axis Options" I have useless options like "Interval between tick marks" and
"Interval between labels."

I thought that selecting "Date Axis" under "Axis Type" would give me the
date options, but it does not appear to have any affect.

What gives?