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.
Bookmarks