Aligning X & Y Axis at Zero

Easiest is probably manually. I formatted the secondary axis to have a minimum of -40 and a maximum of 50 (to coincide with the primary axis's limits of -0.4 and 0.5). If you are unsure how to bring up the format axis dialog: https://support.office.com/en-us/art...3-f9ce41df0021

You will need to do this everytime the primary axis changes, but it is easy.

For this you will need to change the minimum value of the secondary axis in a way that horizontal axis crosses secondary axis at 0.

You can use this simple macro which adjusts the minimum value of secondary axis according to the ratio of primary axis. (It is assumed primary axis crosses the x axis at 0)

Sub alignme()
With ActiveSheet.ChartObjects("Chart 2").Chart
x1 = .Axes(xlValue).MinimumScale
y1 = .Axes(xlValue).MaximumScale
r1 = x1 / y1
y2 = .Axes(xlValue, xlSecondary).MaximumScale
x2 = y2 * r1
.Axes(xlValue, xlSecondary).MinimumScale = x2
End With
End Sub

Check attached. You can just press that button to align.

X & Y.xlsm

Excel does not have a built in "automatic" way to relate the secondary axis values to the primary axis. If you do not like manually changing the axis limits, I can make two further suggestions.

1) Use a charting application other than Excel. I have used other charting applications (temporary trial basis only) which had the option to format the secondary axis as a function of the primary axis.

2) You can use a "dummy series and format it to look like an axis" kind of approach. Something like this: https://peltiertech.com/secondary-ax...tional-scales/

3) You can use VBA to read the primary axis limits and set the secondary axis limits to something reasonable. You did not seem to like the idea of trying to use VBA, so I will not pursue this further.

Assuming that you really want to use Excel for this, approach 2 is probably the next one to look at.

Sure, firstly copy the code from Post #6. Now open your workbook, press Alt+F11, a new window will pop up. Now go to Insert >> Module >> Paste this code in the white area.

Now, insert a shape on the sheet where you have the chart. Right Click on the shape >> Assign macro >> and select "alignme".

Now just press the button to align the axis.

Also, you have to change the "Chart 2" in the code to whatever the name of your chart is.

Glad to know we could help!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

@MCII: This forum strongly discourages posting your question in another person's thread -- even if it is similar. They strongly prefer that you start your own thread. You can (I think) provide a link to this thread, if you feel it will help to explain your question.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread