Hi Jeff,
To make the Y axis visible/invisible with VBA, you can use the following code:
To make the Y axis visible:
Formula:
[list=1][*]ActiveSheet.ChartObjects("Chart 1").Activate 'Replace "Chart 1" with the name of your chart[*]ActiveChart.Axes(xlValue).Select[*]Selection.TickLabels.Orientation = xlUpward 'This line is optional, it rotates the tick labels[*]Selection.Format.Line.Visible = msoTrue[/list]
To make the Y axis invisible:
Formula:
[list=1][*]ActiveSheet.ChartObjects("Chart 1").Activate 'Replace "Chart 1" with the name of your chart[*]ActiveChart.Axes(xlValue).Select[*]Selection.Format.Line.Visible = msoFalse[/list]
You can use these code snippets in your existing code to make the Y axis visible, set the scale, and then hide it again.
Hope this helps!