Excel - Chart - Do Not Chart Zero Value?
I have a chart for the year, tracking my weight gains and losses. This is May and there's this big line falling from the last entry down to the zero mark. how can I make the chart IGNORE zero values and not attempt to chart them?
My chart exists on a different tab. The tab collects data from the various months and auto-fills whatever I enter into a given date. Since the bulk of the months are blank the chart page is returning a ZERO value for those cells and charting the zero point.