A big shout out to Pete who submitted this answer to my last Friday Challenge.
You can check out the challenge here:
Check out the video and download the free Excel template file below.
Here is what Pete is doing:
1) Created Data Range linked to Check Boxes
2) Created Formulas to Show Data or #N/A based on Check Box Values
3) Created a Chart on the Formula Data
4) Created a Macro to hide rows (thus hiding the chart lines) when a #N/A is Present.
(Pete, let me know if I got it wrong )
Check it out by checking the check boxes in the file below.
Thanks for an inventive solution Pete.