+ Reply to Thread
Results 1 to 4 of 4

Dynamic date range selection from pull down menu and auto chart update HELP

  1. #1
    Registered User
    Join Date
    05-02-2020
    Location
    southern California
    MS-Off Ver
    2016
    Posts
    11

    Dynamic date range selection from pull down menu and auto chart update HELP

    Hello forum,

    i am looking to add a dynamic date range selection for some data

    choosing a date will pull all corresponding data (Date, time, OHLC, volume and VWAP) applicable to that day

    and update charts on chart tab automatically

    complex data selection as choosing another date will shift the data being pulled from cells in multiples of 78 up or down

    architecture and example with formula on dynamic date range tab. charts on chart tab are supposed to auto update with selection of a new date.

    hope this makes sense.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,871

    Re: Dynamic date range selection from pull down menu and auto chart update HELP

    Perhaps this proposal will help.
    1. Set up a range for only the data of the date selected in O1:X79 on the 5 min bar with VWAP sheet.
    1a. Column O is populated using: =IFERROR(INDEX(B$2:B$391,AGGREGATE(15,6,(ROW(B$2:B$391)-ROW(B$1))/($B$2:$B$391=Chart!$AT$2),ROWS($A$1:$A1))),"")
    1b. Columns P:X are populated using: =IF(O2="","",(INDEX(C$2:C$391,AGGREGATE(15,6,(ROW(C$2:C$391)-ROW(C$1))/($B$2:$B$391=Chart!$AT$2),ROWS($A$1:$A1)))))
    2. Cell AT2 on the sheet is the drop down with a source of: ='5 min bar with VWAP'!$A$2:$A$6
    3. The chart data range for the OHLC Candle Chart is changed to: ='5 min bar with VWAP'!$Q$1:$T$79
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    05-02-2020
    Location
    southern California
    MS-Off Ver
    2016
    Posts
    11

    Re: Dynamic date range selection from pull down menu and auto chart update HELP

    Thank you so much!
    the formula works perfectly.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,871

    Re: Dynamic date range selection from pull down menu and auto chart update HELP

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. Update Chart data in dynamic range
    By soidog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2019, 08:07 AM
  2. Macro to update chart using dynamic named range
    By VBAClueless in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2016, 07:03 AM
  3. [SOLVED] Dynamic chart title created in VBA does not auto-update
    By DH112213 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2013, 12:38 PM
  4. [SOLVED] Chart date labels don't update (using dynamic named range)
    By s80NL in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-04-2013, 11:35 AM
  5. [SOLVED] Auto update chart range
    By akulka58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2012, 04:15 AM
  6. Dynamic range to update chart, multiple series
    By staples in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-31-2009, 12:26 PM
  7. How to create a pull down menu for selection?
    By Eric in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2006, 11:55 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