How to Create a dynamic weekly chart in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck.

In this Excel tutorial from ExcelIsFun, the 262nd installment in their series of Excel magic tricks, you'll see how to create a Weekly Chart that can show data from any week in a large data set. See how to make dynamic formula chart labels that will show the weekly dates in the Chart Title Label. See how to use:

1. Excel 2007 Table Feature (Ctrl + T)

2. Excel 2003 List Feature (Ctrl + L)

3. Table / List Dynamic Ranges

4 .TEXT function and Concatenation (Ampersand) to create a dynamic Chart Title Label

5.Dynamic Data Validation List that controls what data in displayed in the Chart 6.Custom Number Format for Date Number Format

7. Filter Chart For Weekly Data