Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2010
    Posts
    8

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

    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

  2. #2
    Join Date
    Dec 2010
    Posts
    8
    What about a list/combo box? Can anyone help with a suggestion?

  3. #3
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Can you attach an example workbook?

  4. #4
    Join Date
    Dec 2010
    Posts
    8
    Ok have zipped an example of workbook. I removed some Community names.
    Attached Files Attached Files

  5. #5
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    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...
    Attached Files Attached Files

  6. #6
    Join Date
    Dec 2010
    Posts
    8
    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?

  7. #7
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Sure, you just have to swap the cells the controls are linked to.
    Attached Files Attached Files

  8. #8
    Join Date
    Dec 2010
    Posts
    8
    Thanks for your help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •