Main Profile

At A Glance

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
Length: 16:37

Contact

Questions about Excel Magic Trick 349: Automatic Dynamic Chart for Last Nine Weeks of Data

Want more info about Excel Magic Trick 349: Automatic Dynamic Chart for Last Nine Weeks of Data? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question