|
Re: How to get empty cells not to show up on graph (not even as 0 )
Well, hiding the row with the blank cell will cause it not to be displayed in the graph.
If you need a 'smarter' solution then use formulas to rearrange the data so as to 'skip over' the blanks, so that you end up with a column of values without blanks, and then have the graph be based on that:
Say your data (including some blank cells) is in column A, starting at A2
Let B1 be empty and in cell B2 have the following thing, and fill down:
=B1 + IF(LEN(A2)=0, 0, 1)
Then in column D, say, starting at D2, just have the numbers 1, 2, 3, ...
Then in column E have =INDEX($A:$A, match(D2, $B:$B, 0)), and fill down
And base your graph on column E.
|