Chart with two different scales on the secondary y axis?

Originally Posted by MrShorty

I found this tutorial: https://engineerexcel.com/3-axis-graph-excel/

Thanks MrShorty! Nice find.
That's exactly the look that I am after.

The problem is that this is not for a one-off chart.

I am using VBA code to create more than 100 charts on a daily basis.
And each chart has different axis requirements.
One of the extra axes may have a range from 0-400,
while the next may be 0-2000, and the next 0-5000, etc.

The VBA code would first need to check the data for each site,
find its axis range, then tailor the chart accordingly.