Highlight certain Y axis intervals on a scatter chart

[mbw00001]

I am trying to find a macro to highlight certain intervals on the Y axis of a scatter chart. Interval top and bottom are stored in cells at the same sheet of the chart A

 

[GlennUK]

You could add a couple of extra series and try the tricks shown by Jon Peltier: Fill Under or Between Series in an Excel XY Chart - Peltier Tech Blog

 

[mbw00001]

Thank you GlennUK This worked fine for me