+ Reply to Thread
Results 1 to 2 of 2

Scroll bar isn't moving data (Form Control)

  1. #1
    Registered User
    Join Date
    06-21-2013
    Location
    west allis
    MS-Off Ver
    Excel 2007
    Posts
    28

    Scroll bar isn't moving data (Form Control)

    I created two graphs that have scroll bars associated with them. The scroll bars allow me to adjust how many data points are viewed and I shouldn't ever have to refresh the data points (multiple names with offset functions). However, when I copied the spreadsheet tab to another workbook, the scroll bar moves, but the data in the graph stays the same. Would love a solution that re-links the scroll bar to the data...

    Thanks


    FYI - I have attached the good and bad workbooks.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Scroll bar isn't moving data (Form Control)

    The dynamic names are missing from the series values; they've been replaced with the worksheet range addresses. Ergo, select Data source, Edit, etc.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Scroll bar form control won't stop
    By Bishonen in forum Excel General
    Replies: 1
    Last Post: 07-13-2013, 12:10 PM
  2. How to use a Scroll bar (form control)
    By RA_Lek in forum Excel General
    Replies: 2
    Last Post: 07-07-2013, 11:18 PM
  3. Scroll Bar (Form Control) is lagging when scrolling
    By AlphaSkidz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2013, 10:43 AM
  4. Scroll bar (Form Control) - Resetting the scroll bar to particular values
    By Vishb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2011, 04:10 AM
  5. Moving a form button with scroll
    By dssrun209 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2011, 10:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1