VBA Chart: Move the vertical axis to the left side of the chart.

[vbagreco]

Hi all,

I have a Dynamic VBA Bubble chart that gets updates regularly and many of the X values are negative. As many of the x Values are close to 0 there are overlaps and the chart is not easily readable. For this reason I want to move the Y axis (vertical) to the left side and stay there even when I have points with negative X values., but I haven not found the way to do that . Would anyone know if this can be done?

Thank you in advance

 

[sijpie]

Sure: in the properties for the axis, you can set the axis to be at the maximum value