Friday Challenge Answer – Dynamic Excel Chart Using Checkboxes for Multi Year by Month Data

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

image

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

image

2) Created Formulas to Show Data or #N/A based on Check Box Values

image



3) Created a Chart on the Formula Data

image

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 Smile)

 





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









3 COMMENTS

  1. 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

LEAVE A REPLY

Please enter your comment!
Please enter your name here