How to make "secondary x axis labels"
 

Ive added secondary y axes before, so you can have a series relating to the
left hand axis and one on the right, but with a common x axis

but is there an easy way to have two x axis, one at the top and one at the
bottom. i don't actually need a 2nd series, but I want my charts to have one
unit across the bottom (dose) and another along the top (exposure index)
just for reference, so that visually I can look at the curve and read off
either dose (at the bottom of the chart), or exposure (at the top)

thanks in advance

A simple way to do it is to plot your data twice. change the axis on one and
set line and sybol to none for one.
in input the two x lable sets

"Lee Harris" wrote:

Ive added secondary y axes before, so you can have a series relating to the
left hand axis and one on the right, but with a common x axis

but is there an easy way to have two x axis, one at the top and one at the
bottom. i don't actually need a 2nd series, but I want my charts to have one
unit across the bottom (dose) and another along the top (exposure index)
just for reference, so that visually I can look at the curve and read off
either dose (at the bottom of the chart), or exposure (at the top)

thanks in advance

"Lee Harris" wrote:

Ive added secondary y axes before, so you can have a series relating to
the
left hand axis and one on the right, but with a common x axis

but is there an easy way to have two x axis, one at the top and one at
the
bottom. i don't actually need a 2nd series, but I want my charts to have
one
unit across the bottom (dose) and another along the top (exposure index)
just for reference, so that visually I can look at the curve and read off
either dose (at the bottom of the chart), or exposure (at the top)

thanks in advance




"bj" wrote in message
...
A simple way to do it is to plot your data twice. change the axis on one
and
set line and sybol to none for one.
in input the two x lable sets


can you do that with x axes though? I've done it before with y axis but not
x axis

Lee -

Sometimes you need to insist that Excel provide the secondary X axis.
When you assign a series to the secondary axis, Excel usually just
provides the secondary Y axis. You can go to Chart Options on the Chart
menu, and on the Axes tab, specify which primary and secondary axes you
want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lee Harris wrote:

"Lee Harris" wrote:


Ive added secondary y axes before, so you can have a series relating to
the
left hand axis and one on the right, but with a common x axis

but is there an easy way to have two x axis, one at the top and one at
the
bottom. i don't actually need a 2nd series, but I want my charts to have
one
unit across the bottom (dose) and another along the top (exposure index)
just for reference, so that visually I can look at the curve and read off
either dose (at the bottom of the chart), or exposure (at the top)

thanks in advance





"bj" wrote in message
...

A simple way to do it is to plot your data twice. change the axis on one
and
set line and sybol to none for one.
in input the two x lable sets



can you do that with x axes though? I've done it before with y axis but not
x axis

"Jon Peltier" wrote in message
...
Lee -

Sometimes you need to insist that Excel provide the secondary X axis. When
you assign a series to the secondary axis, Excel usually just provides the
secondary Y axis. You can go to Chart Options on the Chart menu, and on
the Axes tab, specify which primary and secondary axes you want.

- Jon

thanks Jon, I get that bit, but how is the 2nd x axis included in the chart?
If I add another series it has the same x axis as the 1st, so moving it onto
the secondary y axis won't help. To move it onto a secondary x axis, there
needs to be secondary x axis data, this is where I'm having trouble. If you
just add a series to a chart, and it has a different x axis it messes up the
whole chart. Or maybe I just need to do the chart options and it will refix
itself? I'll give it another go when I get in
cheers

Lee -

If you assign the series to the secondary axis, then get the X axis
through the chart options dialog, both X axes will be the same. Now go
to Source Data (Chart menu), Series tab, and assign the proper X data
for the secondary axis series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Lee Harris wrote:

"Jon Peltier" wrote in message
...

Lee -

Sometimes you need to insist that Excel provide the secondary X axis. When
you assign a series to the secondary axis, Excel usually just provides the
secondary Y axis. You can go to Chart Options on the Chart menu, and on
the Axes tab, specify which primary and secondary axes you want.

- Jon


thanks Jon, I get that bit, but how is the 2nd x axis included in the chart?
If I add another series it has the same x axis as the 1st, so moving it onto
the secondary y axis won't help. To move it onto a secondary x axis, there
needs to be secondary x axis data, this is where I'm having trouble. If you
just add a series to a chart, and it has a different x axis it messes up the
whole chart. Or maybe I just need to do the chart options and it will refix
itself? I'll give it another go when I get in
cheers