You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Hide 0 data points in Line graphs

Received Response
edited Oct 27, 2020 6:34AM in Narrative Reporting 3 comments


Is 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([1]>0,[1],#Missing)" but this syntax doesn't work.  Does anyone know of another solution?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!