Is there way to hide 0 values on a line in th...

(Chris Landsman) #1

Is there way to hide 0 values on a line in the Row Series [Line] graph?

For example - on the image posted the orange line has no data after the first point, but it’s interpreting the blank data for future months as a 0 value.

The graph compares one year of sales to another, and I’d like to have this year’s line (orange) fill is as the data is compiled.

I’ve tried different values and conditional formatting, but can’t get it to work.

(Bellave Jayaram) #2

AFAIK, you cannot do what you are asking for currently

(Steven Coile) #3

Use a slice to omit the zero-value rows, then graph that slice.