Hide 0 data points in Line graphs
SummaryIs it possible to hide data that equals 0 on a line chart?
We have a line chart with a 0 value for the latest month of actuals. Is it possible to hide this data point? I can get it to show as a dash or empty in the source grid but it still displays in the chart as I think regardless of what it displays in the grid it still recognises the underlying numbers as a value of 0. I was thinking potentially using an IFTHEN formula such as "IFTHEN(>0,,#Missing)" but this syntax doesn't work. Does anyone know of another solution?