Challenge

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

Steve True · Jun 12, 2014

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.

File Download:

Video Demonstration:

This embedded resource is unavailable in the restored edition.

Thanks for an inventive solution Pete.

Steve=True

Reader discussion

Comments preserved from the original page. New comments are closed.

June 12, 2014 At 10:16 am

Pete, you inspired Don to update his spreadsheet as he liked the line format. You can check it out here:

July 4, 2015 At 7:53 am

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

July 16, 2015 At 5:00 pm

Hi Gareth,

Steve=True