INTHEBLACK September 2026 - Flipbook - Page 58
WORK SMART
EXCEL TIPS
SUBSCRIBE
to the podcast
INTERACTIVE EXCEL
CHARTS — PART 2
NEALE BLACKWOOD CPA
Building on Part 1, learn how to adapt formulas to work with financial
years instead of calendar years and easily switch between ascending
and descending sorting.
UPSKILL
with CPA Australia’s
Excel in-person
workshops and
virtual classrooms
Excel’s charts typically have static ranges — while the values may update, the size of the chart is
fixed. The first article explains how to add interaction to charts to make them more flexible, how
to let the user control how many months are displayed and give control to the user over what is
plotted on the chart.
Part 2 shows how to extend this even further, using check boxes and other functions to improve
interactivity.
Read the full article
INTHEBLACK, Neale Blackwood CPA: Create interactive Excel charts with dynamic arrays (part 2)
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
58 INTHEBLACK September 2026
