move y-axis labels on column chart from left to right side
 

I have a standard column chart, and want to move the y-axis labels from the
left side of the chart to the right side of the chart, but cannot change type
of chart. this is Excel 2000. Is this possible to do?

Hi,

I have some instructions here,
http://www.andypope.info/tips/tip006.htm

Cheers
Andy

Kaye wrote:
I have a standard column chart, and want to move the y-axis labels from the
left side of the chart to the right side of the chart, but cannot change type
of chart. this is Excel 2000. Is this possible to do?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

also you can select the axis, select patterns and set tick lables high

"Kaye" wrote:

I have a standard column chart, and want to move the y-axis labels from the
left side of the chart to the right side of the chart, but cannot change type
of chart. this is Excel 2000. Is this possible to do?

This doesn't move the tick marks (or the axis itself). Double click the
X axis, and check the Value (Y) Axis Crosses At Maximum box to move the
axis itself.

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


bj wrote:

also you can select the axis, select patterns and set tick lables high

"Kaye" wrote:


I have a standard column chart, and want to move the y-axis labels from the
left side of the chart to the right side of the chart, but cannot change type
of chart. this is Excel 2000. Is this possible to do?