If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to insert 2 scales on y-axis?
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 |
#2
|
|||
|
|||
How to insert 2 scales on y-axis?
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 |
#3
|
|||
|
|||
How to insert 2 scales on y-axis?
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 |
#4
|
|||
|
|||
How to insert 2 scales on y-axis?
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 |
Thread Tools | |
Display Modes | |
|
|