Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Radio buttons, check boxes in Excel 2007 | Excel Discussion (Misc queries) | |||
Check Boxes or Option Buttons | Excel Discussion (Misc queries) | |||
Copying data using Check boxes | Excel Discussion (Misc queries) | |||
how do i filter check boxes? | Excel Discussion (Misc queries) | |||
option buttons or check boxes | New Users to Excel |