Is there a way to hide data points that equal 0 on a line graph? I know there is a way to hide blank fields, but I have monthly data for the upcoming year that is 0 for months in the future.
So for instance: currently there is only January data (cell A16), so that data point I want shown on the graph, but February-December (cells B16:L16) are zero so I do not want them shown on the graph. I do not want to clear them because when data does hit for these months/cells I Want them automatically added to the graph. Is this a possibility?
THANKS!
Bookmarks