+ Reply to Thread
Results 1 to 2 of 2

scrolling/drag chart (similar to stock charts)

  1. #1
    Registered User
    Join Date
    02-06-2021
    Location
    london, england
    MS-Off Ver
    2016
    Posts
    4

    scrolling/drag chart (similar to stock charts)

    Hi, Is it possible to create in excel charts that can be scrolled/dragged (and values adjust automatically)? I have in mind the charts that are constructed on financial websites such as yahoo (finance.yahoo.com/chart/MCD]) that the user can interact with, such as click, drag.

    Thanks.
    John

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

    Re: scrolling/drag chart (similar to stock charts)

    You can use named ranges to control what is displayed within a chart and controls to determine start point and number of data points.

    If you use pivot table to create data then you can make use of Time slicers.
    Cheers
    Andy
    www.andypope.info

+ 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. Have stock chart update stock and clear itself
    By Normonious in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2017, 11:49 AM
  2. Scrolling through date based data on charts
    By TommyG85 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2016, 07:04 AM
  3. charts are disappearing upon scrolling
    By hassan88 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-29-2015, 02:22 AM
  4. Stock Chart combined Dow Jones Stock Chart ?
    By HerryMarkowitz in forum Excel Charting & Pivots
    Replies: 17
    Last Post: 10-14-2014, 07:30 AM
  5. Stock charts - how to use different colours in chart
    By AndrzejSob in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-07-2013, 04:37 PM
  6. Scrolling Charts
    By mangeshp4 in forum Excel General
    Replies: 5
    Last Post: 01-28-2011, 07:29 AM
  7. Prevent drag and drop of a worksheet using Application.OnKey or similar
    By maxcat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2011, 10:45 PM

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