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:
   • Dynamic Charts That Update Automatica...  

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

Subscribe for weekly Excel tutorials, techniques and examples:
   / @theexcelhub  

Please share this video with others that may find it useful:
   • How To Create A Dynamic Chart Using A...  

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

The Excel Hub website: https://theexcelhub.com/
Instagram:   / theexcelhub  

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing valueadding 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:
[email protected]

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