mathias1979
Technical User
I know I can go to chart options and select to skip empty cells when plotting a graph. The problem is, the way I've programmed my spreadsheet, the cells aren't technically empty.
I am averaging groups of cells to create my time series. When there is missing data for a certain time period, the equation is programmed to return a blank to avoid a DIV/0 error...i.e.
=IF(ISNUMBER(AVERAGE(A3:A50)),AVERAGE(A3:A50),"")
But if a period returns a blank value, instead of treating this as a true empty cell and skipping the point on my graph, Excel treats it as a zero.
Is there anyway around this? How can I force Excel to treat this as a true empty cell?
Thanks,
Matt
I am averaging groups of cells to create my time series. When there is missing data for a certain time period, the equation is programmed to return a blank to avoid a DIV/0 error...i.e.
=IF(ISNUMBER(AVERAGE(A3:A50)),AVERAGE(A3:A50),"")
But if a period returns a blank value, instead of treating this as a true empty cell and skipping the point on my graph, Excel treats it as a zero.
Is there anyway around this? How can I force Excel to treat this as a true empty cell?
Thanks,
Matt