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

[@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.

[@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!

[@TravelRunner]

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

[@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!

[@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!

[@jc_777]

Really great. Very useful indeed. Thanks!

[@theexcelhub]

Thank you Jae!

[@bpclubsport7879]

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

[@michaeltree5469]

Great information! Thank you.

[@theexcelhub]

Thanks for watching!

[@go_away_plz]

This was useful, thank you

[@theexcelhub]

Thanks for watching!

[@redfielddonato4196]

How to do this for combo chart?

[@abhinavpatel4488]

very useful, thanks a lot.

[@theexcelhub]

Thanks for watching Abhinav!

[@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

[@ouzytheoriginal]

very good bro thanks for contribution

[@theexcelhub]

Glad it helped!

[@SirChiefUK]

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

[@omarezzat7170]

Thannnksss

[@heavyferrum397]

HOLY SHT!!!! THANKS!

[@bird6021]

thank you
can i do with linear graph?

[@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.

[@SeanArmageddon]

Does this work on bar graphs as well?

[@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?

[@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.

[@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!