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

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 Dy...
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Dynamic Charts That Up...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: theexcelhub.com/
📸 Instagram: / theexcelhub
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:
[e-mail]
Overview: (0:00)
Vertical Table: (0:49)
Horizontal Table: (3:26)

[@laurenceoliver4900]

A Truly excellent tutorial. Concise, yet not rushed. Well laid out and not overly complicated. Well done sir!

[@MrLRankin2]

Perfect! Straight to the point! I thank you, so very much, for this very well done tutorial.

[@TravelRunner]

Thank you for this video. Very straightforward and easy to follow. Great job!

[@rajnajat]

Excellent and concise guidance ! Thank you !

[@noeliamontero3839]

I tried to search for this solution in so many places until I ended up here.. THANKS! you definitely made my day

[@theexcelhub]

Thank you Noelia - very happy to hear that!

[@bpclubsport7879]

Thanks. Can I ask if a chart is created based on table it doesn’t automatically update ?

[@andreasrom6812]

This was amazing! THANK YOU SO MUCH! :D Would never had been able to figure this out by myself

[@theexcelhub]

My pleasure, thanks for watching!

[@michaeltree5469]

Great information! Thank you.

[@theexcelhub]

Thanks for watching!

[@Chef-1707]

This is great…really well explained. Ive been struggling a bit with this but now understand it a lot better. Really helpful you showed horizontal and vertical.

[@theexcelhub]

I'm glad it helped!

[@jc_777]

Really great. Very useful indeed. Thanks!

[@theexcelhub]

Thank you Jae!

[@SirChiefUK]

Thank you for sharing your skills, really helpful. Would that be applicable using a pivot table or just a standard table?

[@go_away_plz]

This was useful, thank you

[@theexcelhub]

Thanks for watching!

[@abhinavpatel4488]

very useful, thanks a lot.

[@theexcelhub]

Thanks for watching Abhinav!

[@bird6021]

thank you can i do with linear graph?

[@markohara2668]

Very Helpful, just wondering can you apply this with multiple variables e.g. Sales and Forecast Sales? Thanks

[@b4bani]

Yes. Add another named range referencing to the new column. For how many rows to take, the reference will remain to the cell with counta formula

[@Dhruv1223]

I was just creating a chart for mapping trends in the indian stock exchange intraday movement, but every video I saw either forced me into converting my chart into a table causing some issued pulling data in, or made me make a chart that was a hot mess. This is the first video Ive seen that helped me make a really professional chart. Thanks so much! Just one question If I delete the data because i want to map the next day movement, excel throws an error and the chart starts from the end of the chart instead of the beginning, is there any way to fix that?

[@SeanArmageddon]

Does this work on bar graphs as well?

[@ouzytheoriginal]

very good bro thanks for contribution

[@theexcelhub]

Glad it helped!

[@heavyferrum397]

HOLY SHT!!!! THANKS!

[@redfielddonato4196]

How to do this for combo chart?

[@omarezzat7170]

Thannnksss

[@dibyajyotinath3071]

If we delete some data from the table, then will it automatically adjust the graph or not ??? I need to create a graph where the data table may increase or decrease.

[@forex7769]

A little bit complicated u need to use sumproduct formula greater or less than nothing to not include formula if auto summing like running total, but better than having to turn data into a table.

[@spar123321]

Im trying to find this, but instead of adding data to the bottom of a list, I want to be able to add a new column each week and not have to amend the formulas.

[@6toolbaseball]

Dumb question, but how is this any better than creating a table?

[@kaylina_electrics]

Didn't work..

[@KusogeMan]

this is kinda bad, i have a huge quantity of columns!