Excel Magic Trick # 262: Dynamic Weekly Chart

Tags:: Excel Weekly Dynamic Chart Labels Title TEXT Function Tables List Mike Gel Girvin Highline Community Colleges

Edit Video Details

Affiliate Submitter:
ExcelIsFun

International
Comments: 0
Views: 182
Added: 19-Feb-09

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