+ Reply to Thread
Results 1 to 3 of 3

How to suppress the display of zero values in a data series?

  1. #1
    Registered User
    Join Date
    06-08-2011
    Location
    Innabox, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    How to suppress the display of zero values in a data series?

    Hi All,

    I have a chart with three data series, 2 series have 52 (weekly data) values each & the 3rd series has between 1 & 52 data values (building up from 1 to 52 over the course of a year).

    If I manually add data values to the data underlying the 3rd series the corresponding chart line increases however if I use a formula to reference whether or not data values should be added (returning a "" if no data is yet required) the data series intreprets this as a zero & shows it as such. If the data cell is blank (no formula) then it is not shown in the data series, which is the effect I need to achieve.

    This is Excel 2007 charting & I would be extremely grateful for a pointer as I'm pulling my hair out here[/SIZE][/COLOR][/FONT] . Thank you in advance, enq.
    Last edited by shg; 07-12-2011 at 10:47 AM. Reason: Great help, gratefully received, case closed!

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: How to suppress the display of zero values in a data series?

    Instead of returning "" with formula, make it return #N/A error with NA()
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    06-08-2011
    Location
    Innabox, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to suppress the display of zero values in a data series?

    That is fantastic - works a treat - Thank you, much appreciated!

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1