Forum Discussion
Plotting blank cells
I am plotting a time series of readings. The dates are converted from "day of the year" to "day of the heating season" by a formula. If the date is in the future when no reading has yet been taken,...
You might use the FILTER function to create a new range containing only the non-blank values, and use that as source range for the chart.
Thanks Hans. That's a good suggestion as a workaround. I was really hoping that I had missed some basic way of telling Excel to ignore the formula that creates the blank cell, and just plot the blank cell. Maybe that doesn't exist.
Joe