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 date bug using a simple formula adjustment

• Learn why helper cells make complex formulas easier to understand

This is the first episode in a two-part series on interactive Excel charts, with the next instalment in September covering more advanced reporting techniques, including financial year reporting.

Tune in now.

Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

There is a useful companion video to go with this episode of Excel Tips.

And you can read more of Neale's Excel articles on INTHEBLACK.

You can find a CPA at our custom portal on the CPA Australia website.

Loving this content?

Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest? Head to CPA Australia's YouTube channel.

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:

With Interest

INTHEBLACK

Excel Tips

INTHEBLACK Out Loud

Search for them in your podcast platform.

You can email the podcast team at podcasts@cpaaustralia.com.au