Lv 7
Tony asked in Computers & InternetSoftware · 3 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?


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

  • 3 years ago
    Favourite answer

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

Still have questions? Get answers by asking now.