Excel 2024 Indirect

Excel 2024 Indirect. Here's how the indirect function will help us to do this. So you create a named range with the =indirect(sheet!&e2&:&e3) part and then use that name in the chart.

Indirect is used to summarise financial results pulling data from around 38. So you create a named range with the =indirect(sheet!&e2&:&e3) part and then use that name in the chart.