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 would work if I could get the OFFSET COUNTIF formula to work.
Any suggestions or different approaches? I should mention that the data the formula will be returning in Column D could be either numeric or alphabetic or a combination of both.
This video (How to Create a Dynamic Chart Range in Excel) shows what I am trying to do, and it would work if I could get the OFFSET COUNTIF formula to work.
Any suggestions or different approaches? I should mention that the data the formula will be returning in Column D could be either numeric or alphabetic or a combination of both.
Last edited: