Link chart axis maximum and minimum to cells | Excel

Change start date and end date of x axis using vba

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

Microsoft Office 365, Beta Channel, Version 2201
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:

[matt]

Great video, straight to the point, easy to hear your voice, and you explain what you're doing at each step of the way. Also, bonus points for the well-titled video making it show up well in google searches.

[carvingsonthewall]

In just one video, you showed me how to use selection and make chart axis dynamic. Amazing! Thank you so much for this video.

[NancyMancarious]

You are AMAZING! Very skilled and knowledgeable.

[sashh]

Great tutorial. Worked perfectly and so well explained. Thank you

[Zeuswigglybum]

Excellent video, very well explained. Clear and accurate. Thank-you!

[rajnajat]

Excellent Thanks a lot ! This has been a major issue for several years and now it appears to have be solved !

[aa]

Awesome training. This was exactly what I was looking for. I'll use max/min of another linked pivot with some padding and bingo!

[happylearning-gp]

Very well explained. Thank you and YouTube that I learn everyday something new in excel

[JC-jfbi]

Best tutorial I've seen, thank you!

[juanfe]

Thenk you very much for this tutorial. Very well explained!

[lawrenceliew]

Thanks so much for sharing this tutorial!

[IGRA]

Great video i never knew i would need, thank you

[garethfloweday]

Fantastic, thanks Karina. I thought one could then use a spin button to change the max and min values on the sheet, making adjustment of the axes really quick and easy, but it seems that it does not work because using the spin button to change the value of the cell does not register the change as required to trigger the subroutine :-(

[argowuryanto]

Thanks so much for the video (explanation).👍👍👍

[sreaedhar]

Hi. In the Syntax "Axes(xlCategory)" in your video, I get the same as "Axes(xlValue)". And another issue is the dates are not changing automatically. I have to run the macro everytime. Kindly suggest

[fhabiano]

Hi! Your video is perfect! I have one only problem I could not fix with your tip... when I change X range, the Y axle does not change range automatically, even with "automatic" option selected. Y axle still keeps the range for all data set, and not for the range select (range that is being viewed). Any suggestion? Thanks!

[johnmcphee]

I have done exactly as outlined in the video but the automatic change is erratic to say the least, and sometimes doesn't occur at all. Any suggestions?

[milesbaker]

I have my chart in its own separate sheet - how can I edit the code to accommodate this? Great video thank you

Thanks I love it. one question, I want to Protect that Sheet because I have slicers to change the axis, but once I protect the sheet a message about debug appear. do you know how to solve it?

[KatieTaylor-kr]

My code is not running automatically. I’m still having to click macro and run macro but I pasted the code worksheet under the change option as instructed?