Thread: Chart that's bringing in zero values

I've searched for a couple of hours and this has me stumped. On the attached spreadsheet, all of my charts are graphing the zero values for the remainder of the year. I have the Chart Options selected to not count zero values. There are 5 tabs that have charts - 071,087,155,PRD, and L&D TREND. I would like for the graphing line to end whenever there is no data to report instead of dropping it all the way down to zero in all of those tabs. It's probably something simple that I'm overlooking.

Thanks.

There is no option to not plot zero.
There is a option to not plot empty cells as zero, but you do not have empty cells.

Either change the data source formula to output #N/A for zero values.

Example for Hidden data cell K53

=IF('071'!N36=0,NA(),'071'!N36)

Or use named ranges. Plenty of examples on the forum of these.