Use dynamic named ranges so your charts update automatically

Here's a really easy setup for displaying data in Excel. The key is to create dynamic named ranges. Watch the video to see how to do it in just a few easy steps.

----------------------------------------­----------

----------------------------------------­----------

Business Insider is the fastest growing business news site in the US. Our mission: to tell you all you need to know about the big world around you. The BI Video team focuses on technology, strategy and science with an emphasis on unique storytelling and data that appeals to the next generation of leaders – the digital generation.

[JohnJones-ubij]

By far the best excel tutorials, thank so much!

[alm]

Excellent Video! Would you be able create a dynamic range for say the most recent 5, 10, 20 years? This way, you can always see the annualized returns of 5, 10 20 years without needing to manually adjust the named ranges (as the data increases with each increase in date)?

[sureshprabhu]

Thanks for video, I have not understood the source you are getting that dynamic data.

[stevenkoh]

Best video because it is short clear and other people video waste too much time

[kinmeng]

Did you use hyperlink to get stock index information so that can update automatically please teach me or make a video for more detail ! Thank you

[rahulbakshi]

Thanks a lot. Will you please help me to write code to open a list of csv excel files in text format and delete commas from the last line. I have written code working good in windows but not on Mac. I want the code for Mac.

[TheRealOne]

Hi, thank you very much for the information, but what I need is a fixed range for the data I have, I'm handling air quality data, and as I add more data, all I'm interested in is displaying the latest week in a graph instead of manually adjusting the source

[kinmeng]

How to do it in Window OS Microsoft Excel 2010 ? I can't do it because it is not same with mac

[diegolozano]

i want to know how is posiible do that in excel for windows 10 the menu is diferent. is posiible or not?

[antoniobacic]

(How) can we do this with newest dates always on top?

[tonitoni]

Thanks...can you make the same video in exel from Microsoft?

[markk]

This is not the correct formula logic for Excel 2016 Windows Version:

OFFSET(Starting Point Cell, 0, 0, Count(range), 1) -- for a range that is down the rows.
OFFSET(Starting Point Cell, 0, 0, 1, Count(range)) - for range that is across columns.


DO NOT use, ,, as described here.