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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Scatter chart with categories on x-Axis 2
Use text descriptors as Y axis units 1
Positioning x axis at bottom of chart with negative values 5
reverse axis not working as before... 0
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Formatting 'X' Axis -- 2 fundamental differences 7
Chart distorts secondary axis when the x-axis is logarithmic 5

Top