Create interactive Excel charts (part 2)

Can you make Excel reporting more interactive? Yes, you can.
And it's all to do with dynamic arrays.
In the second of this two-part series, discover how to create dynamic Excel charts this time using financial year calculations and checkboxes.
This is useful for finance pros because the techniques allow users more control.
You will learn:

• How to convert calendar year calculations into financial years
• How to use checkboxes to control ascending or descending chart order
• How checkboxes can figure out which metrics appear on a chart
• How PIVOTBY creates two-dimensional reports for chart…