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...
Create a Column Chart with a Macro in Excel
Macro: This macro adds a column chart to Excel. This is an easy to use macro that allows you to q...



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.