Hello,
I have made graphs that update the last 12 months of data on different financial metrics. I have not been able to hide the zero values, as the usual solutions such as the NA() or an IF function that doesn't count the value as it makes the data skip over the cell since it goes back -12 cells on my anchor data series.
I hope I am not being too general, I would be happy to answer more specific questions that I haven't thought of. If there is a solution to treat zeros as gap that would be great.
I am working on Excel 2010.
Thanks in advance,
-jstrydor
I have made graphs that update the last 12 months of data on different financial metrics. I have not been able to hide the zero values, as the usual solutions such as the NA() or an IF function that doesn't count the value as it makes the data skip over the cell since it goes back -12 cells on my anchor data series.
I hope I am not being too general, I would be happy to answer more specific questions that I haven't thought of. If there is a solution to treat zeros as gap that would be great.
I am working on Excel 2010.
Thanks in advance,
-jstrydor
