Link chart axis maximum and minimum to cells | Excel

[@matt18712]

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.

[@Zeuswigglybum]

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

[@carvingsonthewall5468]

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.

[@rajku4129]

Great source of knowledge...👌👌👌

[@sashh8131]

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

[@rajnajat]

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

[@balazslukacs3232]

Köszönjük!

[@happylearning-gp]

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

[@aa9025]

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

[@juanfe9210]

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

[@JC-jf8bi]

Best tutorial I've seen, thank you!

[@lawrenceliew5812]

Thanks so much for sharing this tutorial!

[@melaniehartness2232]

Thanks

[@garethfloweday8030]

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 :-(

[@IG0R1A]

Great video i never knew i would need, thank you

[@sunnybaggu785]

Thank you for the clear explanation

[@agatkazieba]

Amazing! Simple and easy, thank you!

[@argowuryanto5611]

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

[@wilsonnisti9810]

Excellent!! Thank you!😊

[@karlisaacs]

Super tutorial! Thank you

[@adnanchinisi7871]

Very helpful thank you!

[@milesbaker4686]

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

[@01097906]

Thanks Karina!!!!!!!!!!!!! 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?

[@philipvaskoudis4867]

Amazing thank you

[@mahmoudgamal3244]

Thanks you are super

[@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!

[@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!

[@fhabiano]

Hi! Sorry to insist... any comment in my question above?

[@fhabiano]

Nothing?

[@dr.snatcher7365]

Thanks very much !

[@KatieTaylor-k9r]

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?

[@dhirengajwani6588]

In case you face error- 'Invalid forward reference, or reference to uncompiled type' try to enable the "AccessibilitycplAdmin 1.0 type admin" under Tools > References (within the VBA editor)

[@johnmcphee1589]

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?

[@marcw.5492]

Hey really helpful ! I can get all to work But Minimum doesnt want to change ... hmmm. Im gonna try to change the ChartData Range next.

[@BirmDindaeng]

Thank you

[@tuliovargas]

Thanks so much

[@TomaszPawlowicz-gj9pz]

how to do it for few charts in one sheet?

[@anttihoivala6740]

Thank you.

[@migueldayan4702]

When I tried this the data points disappear on my scatter plot do you have any idea why this happens?

[@juliussulit3306]

The macros are working but the automation doesn't. :( I just inserted an action button instead, but hopefully someone can help me on what I may have been doing wrong on the automation.

[@jackt3641]

Great tutorial, any help on how I could adapt this to work for my case? The charts that I'm updating the axes of reside on a different worksheet than the cells containing the dates. Also, this should still work if my date range is =NOW() and =NOW()-30, right? Thank you!

[@jackt3641]

Found a workaround, just referenced the start and end time cells on the sheet with the charts

[@youssefelaskary2152]

thanks for explanation but i have a problem with macro cell "E2" dont change automatically if its value taken from another cell

[@karinaadcock]

A formula updating will not count as a change so the macro will not run

[@youssefelaskary2152]

@@karinaadcock What is the solution for this problem ?

[@youssefelaskary2152]

I use "E2" value from pivot table which will change automatically, What can I do in this case ? thanks for replay

[@youssefelaskary2152]

Thanks a lot for your video problem solved by using calculate with change by the following steps Private Sub Worksheet_Calculate() 'Updateby Extendoffice Dim Xrg As Range Set Xrg = Range("F8") If Not Intersect(Xrg, Range("F8")) Is Nothing Then Macro1 End If

[@minettigiampaolo2476]

@@youssefelaskary2152 Hi, I had the same problem. Could you please explain the variables in your code (Xrg, F8, Macro1) so that it can be adapted to other situations? And where should it go? Thanks

[@kirtanlad]

what if these two cells are controlled by another cell

[@EL34AMP-fq5ns]

Right on! Thx

[@edholt9557]

Sweet!!!!

[@renuka2740]

how to change/link the minimum & maximum scale for y axis?

[@movaziri7340]

B U T Fullllll

[@Ghorgolla]

Oooh the mummy lilt is unbearable.

[@TommyFielding]

Thankyou, this tutorial was great