A big shout out to Pete who submitted this answer to my last Friday Challenge.
You can check out the challenge here:
Friday-challenge-excel-mutli-year-graph-by-month
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.
File Download:
Petes-Friday-Challenge-Mutli-year-Graph-by-Month-Solution.xlsm
Video Demonstration:
Thanks for an inventive solution Pete.
Steve=True
Pete, you inspired Don to update his spreadsheet as he liked the line format. You can check it out here:
https://www.exceldashboardtemplates.com/Updated-Don-Step-Chart-Friday-Challenge-Data-with-Line-Chart.xlsx
Hi,
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.”
Many thanks,
Gareth
Hi Gareth,
There is a file download at the bottom of the post where you can see the VBA code used.
https://www.exceldashboardtemplates.com/friday-challenge-answer-dynamic-excel-chart-using-checkboxes-for-multi-year-by-month-data/
Steve=True