Does anyone have any suggestions on how to insert 2 scales on y-axis? one
scale on the left and the other scale on the right.
Thanks in advance for any suggestions
Eric

I have just put up a file at:-

http://www.pierrefondes.com/

It is item number 26 at the top of my home page.

What follows is said in reference to the above file (called secondary_axis).

Take the following action in EXCEL 2007:-

- click somewhere in one of the blue columns (on chart itself)

- this will place blue circles around those columns

- right hand click and select Format Data Series

- Format Data Series pane should launch (and should have Series Options
highlighted in the top left hand corner)

- select the Secondary Axis radio button towards the bottom of the screen

- Close

Please hit Yes if my comments have helped.

Thanks.





"Eric" wrote:

Does anyone have any suggestions on how to insert 2 scales on y-axis? one
scale on the left and the other scale on the right.
Thanks in advance for any suggestions
Eric

See
Case Study – Single chart dual axis
http://www.tushar-mehta.com/excel/ch...ual%20axis.htm


On Wed, 30 Dec 2009 06:55:01 -0800, Eric
wrote:

Does anyone have any suggestions on how to insert 2 scales on y-axis? one
scale on the left and the other scale on the right.
Thanks in advance for any suggestions
Eric
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins

The easiest way I know how to do it is when you insert your chart, go to
custom types and scroll down to the one that says Line - Column on 2 axes,
and that one will give 2 scales for your y axis.

"Eric" wrote:

Does anyone have any suggestions on how to insert 2 scales on y-axis? one
scale on the left and the other scale on the right.
Thanks in advance for any suggestions
Eric