[Solved] Prevent a graph from drawing empty cells?
Posted: Fri Jan 18, 2019 12:02 pm
Hi,
I'm trying to make a graph that should update every time I add a new row. I've set the range to about 1000, but it draws all of those points.
In one of the columns, there is a formula, but it is set to keep the cell empty unless the other cells in that row are populated.
I've already unchecked "Include values from hidden cells", that didn't work.
When I choose "assume zero" it draws the line at 0 at all those cells, so they are recognized as missing cells I assume.
Does anyone know how I can make it so that those missing cells don't draw on the graph at all?
Thanks in advance,
Ashley
I'm trying to make a graph that should update every time I add a new row. I've set the range to about 1000, but it draws all of those points.
In one of the columns, there is a formula, but it is set to keep the cell empty unless the other cells in that row are populated.
I've already unchecked "Include values from hidden cells", that didn't work.
When I choose "assume zero" it draws the line at 0 at all those cells, so they are recognized as missing cells I assume.
Does anyone know how I can make it so that those missing cells don't draw on the graph at all?
Thanks in advance,
Ashley