+ Reply to Thread
Results 1 to 3 of 3

Remove zero data labels on chart

  1. #1
    Registered User
    Join Date
    08-14-2014
    Location
    toronto, canada
    MS-Off Ver
    2010
    Posts
    20

    Remove zero data labels on chart

    Hi everyone

    I have a pie chart from a dataset. I want to remove the 0% labels within the pie chart.

    I would manually remove them but the numbers can change based on parameters. I also have 28 of these pie charts.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,259

    Re: Remove zero data labels on chart

    Try this:
    First, delete the zero values. If using formulas, include condition to exhibit #N/A instead of zero.
    Over chart area, right button options, click Select Data.
    At dialog box, click Hidden and blank cells.
    At new dialog box, click Show data in hidden rows and columns.

    Not sure about precise English version for those commands, but they will show something like that.

    Godspeed!
    Last edited by Estevaoba; 07-25-2017 at 05:14 PM.

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Remove zero data labels on chart

    Hi,

    If you only need to remove the data labels, you can apply a custom numberformat of 0%;-0%;; to them, so that 0 values will not display.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Pie Chart - Remove Zero Value Labels
    By Janc in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-22-2018, 06:26 AM
  2. Remove Category Data Labels in Pie Chart That are 0%
    By help_me_123 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-14-2017, 05:32 AM
  3. Replies: 3
    Last Post: 05-05-2015, 02:07 AM
  4. Add and remove data labels buttons
    By Jabba69 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-06-2014, 05:26 AM
  5. Pie Chart - Remove Legend labels that have no value
    By Lizzie123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2013, 05:21 AM
  6. remove labels with a 0 value from axis in pie chart
    By ea223 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-23-2013, 05:30 AM
  7. Remove Data Labels on a bar chart if value = 0
    By Grimace in forum Excel General
    Replies: 7
    Last Post: 02-06-2011, 05:32 PM

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