Hello, am trying to set up a chart based on dynamic data from a table that contains formulas, which includes blank cells. Is there a way to dynamically make this chart work despite the formulas, so that cells with no values do not appear in the chart?
The attached shows a sample of a chart, showing the values, both with and without data. I attempted to use an offset formula but the blank cells with formulas are still showing. Thanks for any input, appreciate any assistance.
Sheryl
Bookmarks