+ Reply to Thread
Results 1 to 4 of 4

Let Excel Chart don't show "0" data

  1. #1
    Registered User
    Join Date
    01-04-2014
    Location
    Taiwan
    MS-Off Ver
    Excel 2007
    Posts
    4

    Let Excel Chart don't show "0" data

    I have some cells have formula and the formula returns "blank" result. In Excel chart, it will show "0" data in X axis. Can we let Excel don't show such kind of data in Chart? Thanks.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    6,805

    Re: Let Excel Chart don't show "0" data

    instead of blank - return #N/A
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    01-04-2014
    Location
    Taiwan
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Let Excel Chart don't show "0" data

    Dear Sir,
    Thanks for reply but I want to have clean cells without #NA.

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    6,805

    Re: Let Excel Chart don't show "0" data

    dont know of any other way ,i'm afraid

    you could use conditional formatting to turn the font white to match the background and so not visible

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  2. Replies: 2
    Last Post: 06-25-2013, 12:43 PM
  3. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  4. Replies: 4
    Last Post: 02-03-2008, 05:11 PM
  5. [SOLVED] EXCEL allow 2 options on status bar e.g. show "Count" + "Sum"
    By LEJM in forum Excel General
    Replies: 1
    Last Post: 08-15-2006, 06:50 AM

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