Dynamic Scrolling Chart in Excel | Line Chart

[@ashwinikumar1926]

Excellent info.I was precisely looking for this very info.Explained in such a simple manner.God bless you.

[@LeanExcelSolutions]

Glad it was helpful!

[@samuelruiz1920]

Great video! What if the table is arranged horizontally, how do I adapt the OFFSET formula?
Thank you!

[@LeanExcelSolutions]

Yes, you can.
Only change the link of scroll bar to column offset

[@yosephineparamitha]

you've saved my life. thanks a bunch

[@LeanExcelSolutions]

😊

[@ronmilkman]

Great video. I have one question. Can a target line be added to the chart that also moves dynamically?

[@LeanExcelSolutions]

Yes, absolutely

[@shivangsharma2329]

my offset function is not working the way it should, i'm selecting data for only wholesaler sale type then it is also giving #VALUE! error☹

[@sshrek1996]

I do not have a developer tab. Any reason for it ?

[@LeanExcelSolutions]

You may need to enable it. Use Customize Ribbon in the Excel Options to enable it

[@saungaye9717]

What version are you using? As for me 2016 and didn't happen like you show in video for offset function. It showed #VALUE if I set height to 10. SAD.

[@LeanExcelSolutions]

Hi, I am using office 365 subscription.
In 2016, it will not work the I demonstrated, since it is creates dynamic range.
But still if you follow the complete steps (using Name manager & set the chart range as it shows in video), the chart will work in same way.

[@gunjansrivastava1988]

Mam it is showing error again

[@johndaved.foronda79]

@@LeanExcelSolutions it is not working...

[@hemaalakshmiipb1953]

HOW TO COPY SCROLLBARS TO ANOTHER SHEETS ?? ITS NOT WORKING WHEN COPIED TO ANOTHER SHEET ALTHOUGHT THE GRAPH CHANGES IN ORIGINAL SHEET BUT NOT WHERE IT IS MOVED???

[@mohamedmoawad1845]

Great work
I can't download the file

[@nohahesham3335]

can't find the source data

[@LeanExcelSolutions]

Hi, please check, link is in the description.