+ Reply to Thread
Results 1 to 1 of 1

Removing zero values from charts

  1. #1
    Registered User
    Join Date
    Boston, MA
    MS-Off Ver
    Excel 2007

    Removing zero values from charts

    I know that this topic has been brought up before, but no solution seems to carry over to my situation. I tried solving this with an autofilter & macro, but I find that this hides the entire rows, which contain valuable data in my worksheet. I do not want to expand into other worksheets because I am trying to keep my database clean.

    What I want to do is this: Create a pie or bar graph containing the attendance percentages or counts for different activities offered by a program over the past year. The problem is that I left room for program expansion, so activities might be added to the list at any time, so the data range is dynamic. Any way to drop out any values that are zero?

    Example is attached. Activity attendance is recorded in 'Activity Entry' page. Much thanks.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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