How To Create A Dynamic Chart Using A Scroll Bar In Excel

We cover how to create a dynamic chart with a scroll bar in Excel. In our example, we have the historical daily stock price data for a fictitious company from the start of 1999 to the end of 2004. Due to the sheer amount of data we’d like to display, our line chart currently looks messy. To overcome this, we’ll cover how to insert a scroll bar which allows you to show 1 years worth of data at a time and scroll through the remaining data. We will also create dynamic ranges using the OFFSET function which we will then apply to our chart.

Dynamic Charts That Update Automatically In Excel - Using OFFSET To Create Dynamic Ranges:

Easy Method To Make Dynamic Charts - Format Data Source As A Table (No OFFSET Needed):

Subscribe for weekly Excel tutorials, techniques and examples:

Please share this video with others that may find it useful:

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:

Overview: (0:00)
Insert scroll bar: (0:38)
Create dynamic ranges: (2:55)
Apply dynamic ranges to chart: (4:40)

[accountsvalue]

Awesome tutorial, well explained and put together. Thank you 🙏🏽

[dimitarbushkalov]

Thanks for this. What do we do when we have more than 1 value against each date? In your case you have only one amount of money against each date, but how do we aggregate this in the chart, if we have 10 amounts of money for each date, i.e., each date repeats 10 times. Thanks

[Sourenics]

Can we also set a button to the chart to show all the data on the graph to alternate between "complete" and "ranged"?