First post. I hope it's not too dumb.
My little problem is fairly simple, I add new data to a spreadsheet every day (or week) and have it show up on a chart. But, some of the chart data is created by a formula based on the data I input. So, in order for the chart to look 'good' (relative term), I have to have the blank or zero results come out as NA() for all the columns I have yet to enter data for - per Jon Peltier's 2009 article (http://peltiertech.com/WordPress/min...g-empty-cells/).
That's OK, but it there any way of making the empty (future) data portion look nicer? If I use NA() as the result of my formula then, of course, this results in '#N/A' (or '###' if the column is too slim) in the cell. And if I try to use 0, space (" "), blank, or copy a blank cell, then the chart treats this as a zero and the chart has a waterfall effect.
This may not have a solution (that fact that I've got a formula in the cell that I want my chart to treat as 'empty' seems to indicate this).
Bookmarks