Dynamic Scrolling Chart in Excel | Line Chart

✔ Link to download the file:

In this video, you will learn to create a scrolling chart using a line chart & scroll bar.

Timeline:
0:00 Overview
1:20 Add a Scroll Bar
2:20 Create Chart Range - Name Manager, Offset Function, Scroll Bar Link.
6:22 Insert Line Chart and link to Chart Range

#dynamiccharts
#excel
#exceltemplates
#leanexcelsolutions #msexcel #dynamicgraph #excelmagic #exceltips&tricks

Be sure to follow the links to stay in touch:

[ashwinikumar]

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

[samuelruiz]

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

Thank you!

[ronmilkman]

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

[shivangsharma]

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☹

[yosephineparamitha]

you've saved my life. thanks a bunch

[saungaye]

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.

[mohamedmoawad]

Great work
I can't download the file

[sshrek]

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

[hemaalakshmiipb]

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???