How to Create an Excel Interactive Chart with Dynamic Arrays




About this tutorial:

Video duration: 00:12:33
Quickly create an automatically sorted Excel bar chart that ALSO lets you hide and show categories on the chart based on a flag in the cell. It’s super easy with Excel dynamic arrays – specifically with the new Excel FILTER and SORTBY functions.

This is especially useful for Excel dashboards to include interactive charts depending on a selection.
The solution will be fully dynamic, i.e. we will not use manual filter or manual hiding. We will even take it another step further and automatically sort the Excel chart based on the visible sales data.

To get that setup we will use Excel’s…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads