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!
🌍 The Excel Hub website: [ Ссылка ]
📸 Instagram: [ Ссылка ]
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:
theexcelhub@outlook.com
Overview: (0:00)
Insert scroll bar: (0:38)
Create dynamic ranges: (2:55)
Apply dynamic ranges to chart: (4:40)
Ещё видео!