+ Reply to Thread
Results 1 to 2 of 2
  1. 11-18-2009, 05:39 AM #1
    Pasha81
    Pasha81 is offline
    Forum Contributor
    Join Date
    05-13-2009
    Location
    London, England
    MS-Off Ver
    Excel XP
    Posts
    174

    Removing empty categories from Pie chart

    Hi

    simple question i think - I'm trying to get rid of all the categories with '0' value in a pie chart ( I dont want the category name to appear).

    any idea how this can be done?

    thanks
    Reply With Quote Reply With Quote
  2. 11-18-2009, 06:50 AM #2
    teylyn
    teylyn is offline
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: Removing empty categories from Pie chart

    Hi Pasha,

    quoting Jon Peltier
    In an area or pie chart, the best approach is to use the null string “”, in conjunction with a number format that suppresses the display of zero values.
    You can suppress the zero value with the custom format

    0;;;

    Read the full article here http://peltiertech.com/WordPress/min...g-empty-cells/

    hth
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0