I have 10 check boxes inserted into a sheet and each of them displays/hides a particular region (ex: North, East, Midwest, etc...). If checked, the bar graph will populate with the sales number associated to the region(s).
My issue is that if I unselect one of the boxes, the table displays the #N/A label. I know I can change the NA() to a "" if I want the label to be blank, but I want it to be completely removed from the graph and have the graph resize to only display the selected regions.
Is this possible to do? I've experimented with basic macros/pivot table methods to solve my issue, but I haven't been able to get it precisely as I need.
Thanks for the assistance!
Bookmarks