+ Reply to Thread
Results 1 to 4 of 4

Dynamic Chart range by User Input

  1. #1
    Registered User
    Join Date
    12-27-2015
    Location
    Iowa, USA
    MS-Off Ver
    2010
    Posts
    83

    Dynamic Chart range by User Input

    Seems I had this figured out at one time, but can't seem to duplicate it again, probably because I took the long way around to do it, but...

    Consider column A1:An with dates beginning 1/1/2020 through whatever, and column B with some associated data. In D1 the user enters a begin date, D2 an end date, and they can enter any dates along the range in column A. How do I chart only the range they've entered? I'm sure I've used named ranges but can't quite get the formula correct. Thoughts?

    Lewis

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: Dynamic Chart range by User Input

    Hi,

    I would use two named ranges, dates and values

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then use the named ranges as the chart data.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    12-27-2015
    Location
    Iowa, USA
    MS-Off Ver
    2010
    Posts
    83

    Re: Dynamic Chart range by User Input

    Thank you sweep! I knew the solution was in named ranges, but couldn't get the syntax right. I'll give it a shot and reply with results later.

  4. #4
    Registered User
    Join Date
    12-27-2015
    Location
    Iowa, USA
    MS-Off Ver
    2010
    Posts
    83

    Re: Dynamic Chart range by User Input

    Thank you sweep! That worked nicely.

+ 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. A Dynamic User-Input Table?
    By whahmira in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-17-2019, 05:10 AM
  2. [SOLVED] Chart with dynamic range based on user input
    By vizzkid in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-25-2018, 10:36 AM
  3. Generating a Dynamic table based off user input
    By Sparkplug90 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2017, 06:33 PM
  4. Replies: 0
    Last Post: 12-10-2014, 11:30 AM
  5. [SOLVED] Project Timeline with Dynamic Date Range Based on User Input
    By Rollinstone12 in forum Excel General
    Replies: 2
    Last Post: 10-28-2012, 10:07 AM
  6. Dynamic Range with user input
    By jj72uk in forum Excel General
    Replies: 4
    Last Post: 03-24-2011, 04:40 PM
  7. Dynamic calculations according to user input
    By David in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2005, 04:05 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