Excel Forum

Excel Dynamic Chart #9: 4 Week Chart Dynamic Formula & Dynamic Data Validation Formula

See a formula setup to create a dynamic 4 month chart. Learn about:
1)Data Validation Custom with a true false formula for a date range
2)DATE, YEAR, MONTH functions
3)ROWS function
4)SUMIFS and SUMPRODUCT functions
5)AND, MAX and MIN functions for data validation logical formula
6)TEXT function for dynamic chart label

Chart created from transactional data not aggregated data.

Got a Question? Ask it Here in the Forum.