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.
Bookmarks