Excel Forum
Similar Content
Dynamic Charts in Excel - The Easy Way
Tutorial: How to create dynamic charts that update automatically when new data is added to Excel. T...
Dynamic Formulas that Update When you Add Data in Excel
Tutorial: I'll show you how to make formulas and functions that automatically update when more data...
Combine Multiple Chart Types in Excel to Make Powerful Charts
Tutorial: In this tutorial I am going to show you how to combine multiple chart types to create a si...

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

Got a Question? Ask it Here in the Forum.