-
First get your data. Make sure its clean and arranged neatly, like
below, in the range B4:E11.
-
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.
Insert check boxes from developer ribbon / forms tool bar
(tip: show
developer ribbon in excel 2007)
-
Now, we want the check boxes to tell whether to show or hide a
particular series of data in the chart. So, link each check box to
one cell, say C13, D13 and E13.
-
We will use IF formula to roast our data based on what the check
boxes say. So, create a similar table and load it with IF formulas
like this:
=IF(C$13,C4,NA())
-
Finally, make a chart with the data in this new table you
created.
-
Put everything together and neatly arrange with your favorite
colors and labels.
-
Serve hot and see your boss drool.
Hi，推荐文件给你 "动态图1.xls" http://vdisk.weibo.com/s/kmzI1
