Buttons or Check boxes to filter data?
 

Hello,

I have data consisting of different names of offices we
have and the amount of claims they submit to us each month.

+------------+-Jan-+-Feb-+
| New York | 10 | 20 |
+------------+-----+-----+
| New Jersey | 13 | 14 |
+------------+-----+-----+
| Boston | 18 | 14 |
+------------+-----+-----+

I have a line chart showing all the offices and with 20+
offices the lines are hard to follow. Boss would like to
see ONE office at a time. The only way I have found to do
this so far is to do auto filter and select the office to
be seen.

I am wanting to find out if it is possiable and how to add
either check box or button to the left side of each office
and if it is checked then show that office on the chart.

Any Ideas?

Thanks
Derek

Buttons or Check boxes to filter data?
 

Jon Peltier has instructions for this on his web site:

http://www.peltiertech.com/Excel/Cha...ByControl.html

Derek wrote:
Hello,

I have data consisting of different names of offices we
have and the amount of claims they submit to us each month.

+------------+-Jan-+-Feb-+
| New York | 10 | 20 |
+------------+-----+-----+
| New Jersey | 13 | 14 |
+------------+-----+-----+
| Boston | 18 | 14 |
+------------+-----+-----+

I have a line chart showing all the offices and with 20+
offices the lines are hard to follow. Boss would like to
see ONE office at a time. The only way I have found to do
this so far is to do auto filter and select the office to
be seen.

I am wanting to find out if it is possiable and how to add
either check box or button to the left side of each office
and if it is checked then show that office on the chart.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html