smartbutdull
IS-IT--Management
I know that there's a way to force a formula to return an error such as #N/A if it matches certain criteria.
I want to do this so that I can plot graphs that miss a point out rather than shooting down to the x axis where there is no data.
Does anyone know how to force an error or any other ways of forcing a chart to miss out zero points?
I want to do this so that I can plot graphs that miss a point out rather than shooting down to the x axis where there is no data.
Does anyone know how to force an error or any other ways of forcing a chart to miss out zero points?