Hide or Unhide Rows/Columns Based on Condition

[Rustico18]

Hello,

In the attached spreadsheet, I'm looking to have the graphs dynamically update on whether the names in the first tab are populated or not. In other words, if any of those names is blank, I'd like the graphs to truncate to only show the other two bars. I believe this can be done using VBA by having it hide/unhide columns O-Q and rows 52-54 dynamically depending on the inputs in the first tab, but not sure how to accomplish this. If you blank out an input in the first tab, the column & row in the second tab should hide, thus getting rid of that entry from the graphs....however, if you then put back in a name in that same first tab cell, the column & row should unhide, restoring that bar to the graphs. Thank you in advance for your help!

[xladept]

Hi Rustico,

This event in the Input Sheet module works except for the coloring on the bottom chart

Please Login or Register  to view this content.

[Rustico18]

Hi Xladept,

That definitely works. Can you help me modify that VBA code for this slightly different format? In the attached, I've moved the inputs onto the same "Summary" tab, and just added a few more graphs. This is exact format of my actual spreadsheet. Thank you!

[xladept]

Try this:

Please Login or Register  to view this content.

The placing of the triggers seems a little awkward

[Rustico18]

Sorry, one more iteration and then I'll be good to go. I changed attached file so that Row 13 lets you select whether you want them "Active" or "Off". If "Off", want to hide that row/column. Thank you so much for your help!

[xladept]

Try this:

Please Login or Register  to view this content.

[Rustico18]

Fantastic. Really appreciate the help.

[xladept]

You're welcome!