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