How do I add an additional X axis in a chart

[Jollybox]

I have a chart that needs two sets of data to be presented relative to a
fixed Y. My 'Y' axis is 'fixed' (in this case depth) the X axis
values/series need two seperate scales (in this case 1, pressure readings and
2, an arbitrary point value.) Ideally I would like the pressure axis (1st X)
to be at the top of the chart, arbitrary point values along the bottom (2nd
X) of the chart.

The chart is a standard type - XY scatter

Thanks for any help or ideas

[Tushar Mehta]

Add both series to chart.

Move one to secondary y-axis (double-click series, select Axis tab,
select 'Secondary')

Select Chart | Chart Options... | Axes tab. Turn on the option for
secondary x axis and turn off the option for secondary y axis.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> I have a chart that needs two sets of data to be presented relative to a
> fixed Y. My 'Y' axis is 'fixed' (in this case depth) the X axis
> values/series need two seperate scales (in this case 1, pressure readings and
> 2, an arbitrary point value.) Ideally I would like the pressure axis (1st X)
> to be at the top of the chart, arbitrary point values along the bottom (2nd
> X) of the chart.
>
> The chart is a standard type - XY scatter
>
> Thanks for any help or ideas
>

[Jollybox]

Thanks for your helpful reply! The chart problem has been solved. I added
the 'second' series data to the secondary Y axis, flipped the X and Y's of
the other sets so the both data series are now on the Y, I discovered one can
only have one X axis scale, then all I do is twist my head 90deg, annotate
the chart and print it out in landscape. Once bound, the chart is in
portrait, so reads perfectly! The only thing left now is to be able to have
five or six data series on the same axis with different scales and life would
be perfect!

Thanks


"Tushar Mehta" wrote:

> Add both series to chart.
>
> Move one to secondary y-axis (double-click series, select Axis tab,
> select 'Secondary')
>
> Select Chart | Chart Options... | Axes tab. Turn on the option for
> secondary x axis and turn off the option for secondary y axis.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <[email protected]>,
> [email protected] says...
> > I have a chart that needs two sets of data to be presented relative to a
> > fixed Y. My 'Y' axis is 'fixed' (in this case depth) the X axis
> > values/series need two seperate scales (in this case 1, pressure readings and
> > 2, an arbitrary point value.) Ideally I would like the pressure axis (1st X)
> > to be at the top of the chart, arbitrary point values along the bottom (2nd
> > X) of the chart.
> >
> > The chart is a standard type - XY scatter
> >
> > Thanks for any help or ideas
> >
>