Results 1 to 8 of 8

Hide legend items in a graph when associated value = zero or blank

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Oakland, CA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Question Hide legend items in a graph when associated value = zero or blank

    I have a graph which picks up Legend Items from column C and percentages from column E. I don't want to delete the rows of information from column C and E where they are blank, as they might be used as process grows. But I don't want these items to appear in the Pie Chart if percentages are zero.

    I've tried clearing any data from those cells, that doesn't work. I end up with an icon for the color within the legend, with no name next to it. I'd like it to not show at all if percentages are zero.

    I've attached a sample Excel file, and I've highlighted the row information in Yellow that I would like to no show in the graph.

    I'm setting this up for others, and trying to automate it as much as possible, so if there is a way to do this so it just happens automatically whenever percentage = zero....that would be incredible!!!

    Thanks for any help!

    - Ben
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Remove N/A legend items
    By Platinum3x in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-21-2013, 06:24 AM
  2. Re-arranging items in Legend
    By ady_mech in forum Excel General
    Replies: 1
    Last Post: 04-18-2008, 04:45 PM
  3. Replies: 1
    Last Post: 09-07-2005, 03:05 PM
  4. [SOLVED] Chart Legend Items: hide/show
    By Richard Ahlvin in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-05-2005, 11:05 AM
  5. Order of items in legend
    By Darryl in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-20-2005, 11:05 AM

Tags for this Thread

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