Closed Thread
Results 1 to 4 of 4

Scroll bar data on two separate charts

  1. #1
    Registered User
    Join Date
    02-04-2018
    Location
    London
    MS-Off Ver
    2017
    Posts
    23

    Scroll bar data on two separate charts

    Hi I need some help. I've Andy Pope's 'scroller' to create a chart which works very well for me. The only thing is, I don't understand how it works. I'm now trying to create a copy of the chart which is related to different data, but I don't know how to change the data reference because it's a SERIES, and I can't figure out how it works. I've attached the file - please see yellow highlighted area (it doesn't look pretty at the moment as I'm in the middle of playing around with it).

    If someone could point me in the right direction it would be much appreciated. My next goal is to create about ten charts on the same sheet all referring to their own set of data, but controlled by the same scrollbar.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Scroll bar data on two separate charts

    You need to use the Name Manager, on the Formulas tab of the ribbon, to define the various named ranges.

    The within a chart you can use the Select Data dialog to enter named ranges rather than cell addresses.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-04-2018
    Location
    London
    MS-Off Ver
    2017
    Posts
    23

    Re: Scroll bar data on two separate charts

    OK I'm confused though because when I look at the data source for the chart there is only one name, 'LEVEL'. I was expecting two, 'LEVEL' and 'EASTINGS'.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Scroll bar data on two separate charts

    Duplicate thread opened in Commercial Services, thread closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Drive multiple charts with different data from one scroll and zoom
    By BRISBANEBOB in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-18-2012, 10:52 PM
  2. [SOLVED] Two separate charts in one (4 sets of data)
    By Eelko-Jan in forum Excel General
    Replies: 2
    Last Post: 04-26-2012, 10:00 AM
  3. Scroll Bars Scrolling Multiple Charts
    By Mordred in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-30-2010, 09:27 AM
  4. Adjusting max property for active charts using scroll bar
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2010, 10:39 AM
  5. Replies: 0
    Last Post: 08-03-2010, 04:11 PM
  6. Organize data into separate charts
    By jebckr in forum Excel General
    Replies: 0
    Last Post: 04-03-2010, 02:46 PM
  7. Replies: 3
    Last Post: 07-26-2006, 05:35 PM
  8. Charts from Pivot Tabels without Scroll Down Bar
    By Angel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-18-2006, 11:10 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