+ Reply to Thread
Results 1 to 3 of 3

Data Label Filter Out Zero in Bar Graph

Hybrid View

  1. #1
    Registered User
    Join Date
    09-21-2011
    Location
    New York, New York
    MS-Off Ver
    Excel 2007
    Posts
    41

    Data Label Filter Out Zero in Bar Graph

    So I have a file that values different properties with a scale of 1-5 in increments of 0.25. The issue I am having is that when I apply data labels to the bar graph, the labels show zero. I can of course manually delete these zeros out, but would rather find a way to systematically do this as it will save me the hassle to do so in the future. Attached is the file for reference. Right now my zeros are filtered by a custom filter to appear as " - ". Thanks for any help in filtering out data labels that show as zero or " -"

    For simplicity Look at Cell G 22

    and G36

    G36 chart is what I want end result to filter to from G22 chart. Thanks for any insights.
    Attached Files Attached Files
    Last edited by JoshF; 06-20-2012 at 04:46 PM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Data Label Filter Out Zero in Bar Graph

    Hi JoshF,

    Right click on the data labels >> Format Data Labels >> Number >> Format Code: >> 0.0%;;;@ >> Add
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    09-21-2011
    Location
    New York, New York
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Data Label Filter Out Zero in Bar Graph

    Quote Originally Posted by jeffreybrown View Post
    Hi JoshF,

    Right click on the data labels >> Format Data Labels >> Number >> Format Code: >> 0.0%;;;@ >> Add
    Thanks a lot. considering I used custom numbers, it seems so silly.

+ 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