Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be 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.

Trending News

Promoted
?
Lv 7
? asked in Computers & InternetSoftware · 4 years ago

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?

Update:

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.

1 Answer

Relevance
  • suzonka
    Lv 4
    4 years ago
    Favorite Answer

    if you can reset the minimum to - minus like -10

Still have questions? Get your answers by asking now.