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
|
|||
|
|||
Scale for double-Y axes
I have an area chart with two Y-axes. I'd like Excel to
keep the scale for the two axes the same - anyone know how? Note: I have a data series which I want to appear as a dashed line - not part of the area chart. That's why I've set-up a second axis for it. If you know a better way I'd love to hear it! |
#2
|
|||
|
|||
Solved it myself
For anyone who's interested I worked it out.
I created a second series on the second Y-axis. This series is equal to the highest point on first axis, less the value of my dashed line. I made this series invisible (no line, no shading). Since it's an area chart my 'invisible series' sits on top of my dashed line, and together they always sum to the highest point on the first axis - therefore Excel sets the second axis to the same scale as the first. |
Thread Tools | |
Display Modes | |
|
|