Hopefully this ones easy!?!??!

I have a chart where I want to dispaly the same x axis both at the top and the bottom of the chart.
Is there a special character to throw in the "cross y axis at" box to cross y at 0 and 100 and therefreo get 2 axis?
cheers
nobby

Hi,

In order to display secondary axis you need a chart with a minimum of
two data series. Even if the second data set is an exact copy of the
first. Move the second series to the secondary axis and then right click
the chart and pick Chart Options. On the axes tab click the X axis option.
http://www.andypope.info/tips/tip008.htm

Cheers
Andy

nobbyknownowt wrote:
Hopefully this ones easy!?!??!

I have a chart where I want to dispaly the same x axis both at the top
and the bottom of the chart.
Is there a special character to throw in the "cross y axis at" box to
cross y at 0 and 100 and therefreo get 2 axis?
cheers
nobby

Plot one of your series (or a dummy series) using a secondary Y axis, then
select Chart Options/ Axes, & change from Secondary Y axis to Secondary X
axis.
--
David Biddulph

"nobbyknownowt" wrote in message
...

Hopefully this ones easy!?!??!

I have a chart where I want to dispaly the same x axis both at the top
and the bottom of the chart.
Is there a special character to throw in the "cross y axis at" box to
cross y at 0 and 100 and therefreo get 2 axis?
cheers
nobby

--
nobbyknownowt