Thursday, 7 November 2019

Excel Macro Code to change x axis maximum scale of chart

Sub setXAxisMaximumScale()
 ActiveSheet.ChartObjects("Chart 2").Activate
    ActiveChart.Axes(xlCategory).Select
    ActiveChart.Axes(xlCategory).MaximumScale = 1
End Sub


P.s. I first recorded a macro and viewed its code to get this

No comments:

Post a Comment

what is a good PhD contribution?

When PhD candidates embark on their thesis journey, the first thing they will likely learn is that their research must be a “significant ori...