I am trying to create a chart with a dynamic range pointing to cells that have formulas in them (in this example - the yellow range). If the formula returns no data, I want those cells to be ignored.
This video (How to Create a Dynamic Chart Range in Excel) shows what I am trying to do, and it...