Copy x axis

N

nobbyknownowt

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
 
A

Andy Pope

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
 
D

David Biddulph

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.
 
Top