"Jon Peltier" wrote in message
...
Lee -

Sometimes you need to insist that Excel provide the secondary X axis. When
you assign a series to the secondary axis, Excel usually just provides the
secondary Y axis. You can go to Chart Options on the Chart menu, and on
the Axes tab, specify which primary and secondary axes you want.

- Jon

thanks Jon, I get that bit, but how is the 2nd x axis included in the chart?
If I add another series it has the same x axis as the 1st, so moving it onto
the secondary y axis won't help. To move it onto a secondary x axis, there
needs to be secondary x axis data, this is where I'm having trouble. If you
just add a series to a chart, and it has a different x axis it messes up the
whole chart. Or maybe I just need to do the chart options and it will refix
itself? I'll give it another go when I get in
cheers