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...
4 Powerful Dynamic Chart Designs in Excel
Tutorial: How to make dynamic charts in Excel that you can change without even clicking the chart -...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.