Change start date and end date of x axis using vba
Excel Date Picker Add-in: http://samradapps.com/datepicker

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = /”$E$2/” Then
ActiveSheet.ChartObjects(/”Chart 1/”).Chart.Axes(xlCategory).MinimumScale = Range(/”E2/”).Value
End If

If Target.Address = /”$J$2/” Then
ActiveSheet.ChartObjects(/”Chart 1/”).Chart.Axes(xlCategory).MaximumScale = Range(/”J2/”).Value
End If

End Sub

———————————————————————————
#exceltutorials #excelcharts #excelvba

SUBSCRIBE: https://goo.gl/c46YPs

Microsoft Office 365, Beta Channel, Version 2201
———————————————————————————
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
– How to quickly change the dates on a chart in excel https://youtu.be/cTBsTzYavag
– How to make an excel chart dynamic using named ranges https://youtu.be/YcEWwE7sO4A

Please take the opportunity to connect and share this video with your friends and family if you find it useful.