A feature that you absolutely need to know to make EASY dynamic charts in Microsoft 365

The chart in this video displays a changing number of categories and can be built very easily from the spill range of a single formula with dynamic array functions. This method is an alternative to using dynamic named ranges as chart references and is available in Microsoft 365 and Excel for the web. In older versions you will still need to use dynamic named ranges for a similar effect. It is important to use one formula for the spill range. In case the necessary columns are non-adjacent in the source data range, include more columns than necessary in the spill range, wrap the formula in the CHOOSECOLS function and specify the column numbers that you need.

0:00 Introduction
0:34 Making the drop-down list with number of months for the chart
1:14 Setting up a spilling formula with the OFFSET function
2:52 Adding a chart to the spill range
3:22 Why it's important to use one formula for the spill range
5:07 What to do if the necessary columns are non-adjacent
6:19 When you can use this method

If you would like to see how to use dynamic named ranges for making charts instead of the feature above, then here is the link to my older video:
   • Excel Chart with Rolling 6 Months, 12...  
For more content like this, please subscribe to my channel.
#MsExcel #ExcelTips
Screenshots used with permission from Microsoft.