 | |
| How to Create an Excel Interactive Chart with Dynamic Arrays |
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 new Dynamic Array functions exclusively available in Office 365.
Related topics:
Post a Comment