Secondary x axis

[Nick]

Hi,

could anyone please instruct me how to fit a secondary x
axis to a chart.

Thanks in advance,

Nick

 

[Guest]

Its okay, i found a way.

-----Original Message-----

 

[Jon Peltier]

For anyone else listening in:

You need two series or more to show secondary axes: at least one series
for the primary axes, and at least one for the secondary axes. Double
click on one of the series, and on the Axis tab, select Secondary. This
only gives you a secondary Y axis. Right click on the chart, select
Chart Options from the pop up menu, and on the Axes tab, select and
unselect the various X and Y axes you want.

- Jon