How to have the Y-axis values on both sides

I am working with a chart that where I would like the Y-
axis to be on both "ends" of the chart (right and left).
If that is not possible I would like the y-axis values to
be on the right side, instead of the usual left side.



Anyone knows how I can do this?

Hi Peter,

To get the y-axis on the right select the x-axis and on the scale tab of
the format dialog check the 'Value (Y) axis crosses at maximum category'
option.

To get two sets of y-axes you will need to add a dummy data series and
move it to the secondary axis. If you use the original data in the dummy
series then the min/max values of the second scale should match the
primary. You will also need to format the dummy series, no border and no
fill. Also delete the legend entry.

Peter wrote:

I am working with a chart that where I would like the Y-
axis to be on both "ends" of the chart (right and left).
If that is not possible I would like the y-axis values to
be on the right side, instead of the usual left side.



Anyone knows how I can do this?



--

Cheers
Andy

http://www.andypope.info

On Thu, 23 Oct 2003 00:52:00 -0700, Peter =

wrote:

I am working with a chart that where I would like the Y-
axis to be on both "ends" of the chart (right and left).
If that is not possible I would like the y-axis values to
be on the right side, instead of the usual left side.

If you have more than one series, you can select one series and go to =

Format | Selected data series | Axis tab and select secondary axis. You=
=

will get a right and left y-axis.

If you want only a right-side y-axis, select the x-axis (*not* the y-axi=
s) =

and go to Format | Selected axis | Scale tab and select "Value (y) axis =

crosses at maximum value."

If you have only one series and you want two y-axes, you'll have to use =
a =

dummy series, chart it against the secondary axis (as described above), =

and format it as invisible.

-- =

Dave
dvt at psu dot edu

As an alternative, you can use my Arbitrary Axis technique to construct
a spare axis:

http://www.geocities.com/jonpeltier/...s.html#ArbAxis

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Peter wrote:

I am working with a chart that where I would like the Y-
axis to be on both "ends" of the chart (right and left).
If that is not possible I would like the y-axis values to
be on the right side, instead of the usual left side.



Anyone knows how I can do this?