View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Derek[_6_] Derek[_6_] is offline
external usenet poster
 
Posts: 15
Default 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