+ Reply to Thread
Results 1 to 3 of 3

Line chart that does not plot zero values

  1. 02-24-2010, 09:40 PM #1
    TrolleyDude
    TrolleyDude is offline
    Registered User
    Join Date
    02-24-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2000, 2003
    Posts
    2

    Post Line chart that does not plot zero values

    I accumulate daily info (numerical) and totaled by month. The running monthly totals are inserted by formula into other cells that will plotted as cumulative data in a line chart. The cells for future months have zero's due to the formulas. How can zeros not be plotted?
    Reply With QuoteRegister To Reply
  2. 02-24-2010, 09:49 PM #2
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Line chart that does not plot zero values

    Hi Trolley Dude, welcome to the forum.

    Have your formulas produce NA() instead of zero. Then these points will not drop to zero but the line will connect straight through to the next point.
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
  3. 02-25-2010, 07:08 AM #3
    TrolleyDude
    TrolleyDude is offline
    Registered User
    Join Date
    02-24-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2000, 2003
    Posts
    2

    Re: Line chart that does not plot zero values

    It Works. Thanks!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1