I am using formulas to populate the source data area for a chart. I am using
percentages, so when the total (divide by) is zero, I want to have an empty
cell. This will distinguish it from a real zero where the numerator is zero.
I am doing the division in another cell as =IF A2=0,"",A1/A2. In the cell I
am plotting from (source data), I am using =Sheet1!A3, where Sheet1!A3 is
where the previous formula is.
When I look at the cell in the source data, it is empty. If I copy and paste
special values, it still looks empty, but plots a zero.
If I delete the cell, then it leaves a gap the way I have it set up in the
Options.
How can I get this cell with the formula to skip in the chart instead of
plotting a zero?