I have put a dynamic chart together to adjust for certain data ranges; however, my empty cells still have formulas so the chart is reading it as actual data points.
Is there is any way around that?
I have put a dynamic chart together to adjust for certain data ranges; however, my empty cells still have formulas so the chart is reading it as actual data points.
Is there is any way around that?
Hi,
You could trap the blank and return it as a NA error, which won't be plotted.
eg =IF(your_formula="",NA(),your_formula)
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks