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.
Pete, you inspired Don to update his spreadsheet as he liked the line format. You can check it out here:
Thanks for the great video. I would like to know how you did point 4)
“4) Created a Macro to hide rows (thus hiding the chart lines) when a #N/A is Present.”
There is a file download at the bottom of the post where you can see the VBA code used.