Line Chart - Aligning the Horizontal Axis at Y=0 on Both Vertical Axes

[andrewc]

Hi,

In the attached workbook I have created a Combo Box from which a user can select a product; this choice will determine the content of the line chart.

I would like to align the horizontal axis to Y=0 on both of the Y-axes.

I can do this manually but this isn't a feasible solution as the Combo Box could potentially contain dozens of products.

Can someone please suggest a better way to align the axes?

If this is to be a VBA solution is it possible to trigger the code to align the axes each time a product is selected in the Combo Box?

Thanks!

[MrShorty]

I can see two approaches:

1) VBA to set both the primary and secondary axis limits and major unit to get the desired effect. This procedure could easily be part of or called from a change/calculate event procedure to further automate it. This is an old one (back before Excel 2007), but the basic idea should still apply: https://peltiertech.com/Excel/Charts/AlignXon2Ys.html

2) "Fake" the secondary axis with a dummy XY scatter series. Basically a variation of this technique: https://peltiertech.com/secondary-ax...tional-scales/

Which approach do you like?

[andrewc]

Thanks very much - I'll take a look to see which I can get to work for me.