Plotting on secondary x-axis

Here's a problem I've been faced with on numerous
occasions. It's simply: How do you plot a second series on
the same graph but with a different x axis range. Note the
plot has to be displayed vertically, cannot be rotated.

Hi Alastair,

Could you not plot it on the secondary xaxis?
To do this double click the data series and on the Axes tab selected the
secondary axis. This normally only changes the yaxis. To include a
secondary xaxis right click the chart and pick Chart Options. On the
axis tab enable the secondary xaxis.

If this doesn't help may you could supply a little more information
about the type of chart you are using.

Cheers
Andy

Alastair wrote:

> Here's a problem I've been faced with on numerous
> occasions. It's simply: How do you plot a second series on
> the same graph but with a different x axis range. Note the
> plot has to be displayed vertically, cannot be rotated.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info