Create interactive Excel charts

Wouldn't it be useful to learn how to build interactive Excel charts that respond automatically to user input using dynamic arrays?

This expert-led episode introduces the core techniques behind flexible charting in Excel, with practical examples.

Key takeaways:

• Create charts that automatically adjust the number of months displayed

• Use SEQUENCE to build flexible dynamic array calculations

• Combine data for charts with the HSTACK function

• Find the latest reporting period using MAX and EOMONTH

• Extract and summarise data with INDEX, MATCH and GROUPBY

• Fix a common dynamic array…