+ Reply to Thread
Results 1 to 3 of 3

Hide Zero Value Data Points

  1. #1
    Dewayne
    Guest

    Hide Zero Value Data Points

    I am using a bar graph to chart services by the quarter. I need data label
    values on the data series that has a value of more than zero but would like
    to hide the data labels for any value that is zero. Is anyone aware of a way
    to hide the 0 value data label until that value of that series is more than
    zero?
    Thanks for any suggestions
    --
    Dewayne

  2. #2
    Andy Pope
    Guest

    Re: Hide Zero Value Data Points

    Hi,

    Use a custom number format (whole values only)
    0;;;

    Cheers
    Andy

    Dewayne wrote:
    > I am using a bar graph to chart services by the quarter. I need data label
    > values on the data series that has a value of more than zero but would like
    > to hide the data labels for any value that is zero. Is anyone aware of a way
    > to hide the 0 value data label until that value of that series is more than
    > zero?
    > Thanks for any suggestions


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

  3. #3
    Dewayne
    Guest

    Re: Hide Zero Value Data Points

    Thanks Andy
    Good Suggestion
    --
    Dewayne


    "Andy Pope" wrote:

    > Hi,
    >
    > Use a custom number format (whole values only)
    > 0;;;
    >
    > Cheers
    > Andy
    >
    > Dewayne wrote:
    > > I am using a bar graph to chart services by the quarter. I need data label
    > > values on the data series that has a value of more than zero but would like
    > > to hide the data labels for any value that is zero. Is anyone aware of a way
    > > to hide the 0 value data label until that value of that series is more than
    > > zero?
    > > Thanks for any suggestions

    >
    > --
    >
    > Andy Pope, Microsoft MVP - Excel
    > http://www.andypope.info
    >


+ 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