Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)
The way you are trying to do it is not possible. Chart data range has to have a fixed address. There is a way around this, and that’s using named ranges Put the number of rows you want in your data in a cell (e.g., E1) So, using your example, I put Number of Rows … Read more