Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
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.
