So, link each check box to one cell, say C13, D13 and E13. Now, we want the check boxes to tell whether to show or hide a particular series of data in the chart.Insert check boxes from developer ribbon / forms tool bar (tip: show developer ribbon in excel 2007) Since our data has 3 series (sales, profits and number of customers), we will take 3 check boxes and place them somewhere on our worksheet.Make sure its clean and arranged neatly, like below, in the range B4:E11. Some data, Few check-boxes, IF formula and a dash of espresso Instructions for preparation:
Are you ready for some excel chart cooking? What our mouth-watering chart will look like when its done: In this post, we are going to learn how to create a dynamic chart using check boxes and formulas. Dynamic charts are like my favorite food, Mangoes.
