|
Featured Tutorial
Featured Macro
Excel Magic Trick 349: Automatic Dynamic Chart for Last Nine Weeks of Data
See how to create a chart for the last 9 weeks of data the automatically changes every Monday. See the Excel features:
1)DATE function
2)YEAR function
3)MONTH function
4)DAY function
5)WEEKDAY function
6)INDEX function
7)MATCH function
8)TEXT function
9)Concatenation using the join symbol ampersand &
10)Formatting as façade
11)Date formatting and Date as serial number
12)Date custom formatting
13)Bar Chart
14)Removing chart junk
15)Varying the colors on chart bars
16)Adding data labels
1)DATE function
2)YEAR function
3)MONTH function
4)DAY function
5)WEEKDAY function
6)INDEX function
7)MATCH function
8)TEXT function
9)Concatenation using the join symbol ampersand &
10)Formatting as façade
11)Date formatting and Date as serial number
12)Date custom formatting
13)Bar Chart
14)Removing chart junk
15)Varying the colors on chart bars
16)Adding data labels