A dynamic chart updates automatically to changes in the data source. To make the chart dynamic, we use dynamic ranges which update automatically as our data changes. There are two ways of creating a dynamic range. Firstly, we can format our data source as a table which is arguably the easier method. This is covered in another video. Secondly, we can use the OFFSET function to create dynamic ranges which is the focus of this video. This method is advantageous if you do not want to format the data source as a table. It also works more effectively when using horizontal tables of data. In this video, we will start by creating dynamic charts from vertical data sources and then create them from horizontal data sources.

Create Dynamic Chart By Formatting Data Source As A Table:
   • 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:
   • Dynamic Charts That Update Automatica...  

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)
Vertical Table: (0:49)
Horizontal Table: (3:26)