Can I use 2 scroll bars to move data? (row and column)

leegun · #1 (**permalink**) 01-15-11, 01:08

Can I use 2 scroll bars to move data on an Excel 2003 dashboard?

Ok I have the date/year and multiple areas that have overtime calculated each month. There are 28 Areas.
I can use =offset and 1 scroll bar to move the date with Area 1. (from this I create a small graph for the dashboard).
I want to be able to scroll between Area 1 to 28 with the overtime columns scrolling, as well as be able on 2nd scroll bar, move the date and number of overtime.
I don't know coding and only know basic Excel with some formulas like offset.

Code:

DATE 	Area 1	                  Area2     (28 Areas)

Jun-10	5	                          6
Jul-10	0	                          7
Aug-10	2.00	                          0.00
Sep-10	0.00	                          0.00
Oct-10	0.00	                          14.50
Nov-10	1.50	                          0.00
Dec-10	4	                          6
Jan-11

leegun · #2 (**permalink**) 01-17-11, 16:40

What about a list/combo box? Can anyone help with a suggestion?

Colin Legg · #3 (**permalink**) 01-18-11, 07:23

Can you attach an example workbook?

leegun · #4 (**permalink**) 01-18-11, 16:16

Ok have zipped an example of workbook. I removed some Community names.

Colin Legg · #5 (**permalink**) 01-19-11, 06:56

I wasn't sure how your chart should look (stacked bar chart? axes?) but I've attached a rough example which should hopefully be sufficient for you to get yours how you want.

Hope that helps...

leegun · #6 (**permalink**) 01-20-11, 18:08

Wow thats great. It is almost exactly how I want it.
Is there a way to scroll say across for dates, and scroll down for each community and show the community name?

Colin Legg · #7 (**permalink**) 01-21-11, 08:07

Sure, you just have to swap the cells the controls are linked to.

leegun · #8 (**permalink**) 01-23-11, 17:36

Thanks for your help

Internet Services

Web Development

Digital Marketing

Consumer Tech