+ Reply to Thread
Results 1 to 2 of 2

Chart with dynamic range based on user input

  1. #1
    Forum Contributor
    Join Date
    03-04-2013
    Location
    Europe
    MS-Off Ver
    Office 365 ProPlus
    Posts
    147

    Chart with dynamic range based on user input

    Hi,

    I'm trying to make a chart where the user can choose to visualize a subset of data in a worksheet based on a start date and an end date. I've created what I think is the correct dynamic formula to account for this, but when I try to put the formula into the Chart>Select data>Series values I get an error saying "That function isn't valid".

    I've made the dynamic formula based on offset and datedif, please see my example workbook attached.

    Why doesn't the chart accept the formula? Is there another (better) way of doing the dynamic chart?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-04-2013
    Location
    Europe
    MS-Off Ver
    Office 365 ProPlus
    Posts
    147

    Re: Chart with dynamic range based on user input

    Solved it myself. Rather crudly, but it works, see attached example file.
    Attached Files Attached Files

+ 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. 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
  2. Replies: 0
    Last Post: 12-10-2014, 11:30 AM
  3. Dynamic Pie Chart Based on User Selection
    By mcollins789 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-03-2013, 06:17 PM
  4. [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
  5. Dynamic Range with user input
    By jj72uk in forum Excel General
    Replies: 4
    Last Post: 03-24-2011, 04:40 PM
  6. Update chart based on user input
    By dasborg in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-16-2008, 11:14 AM
  7. Generating dynamic charts based on the user input
    By shivan4u in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-13-2006, 08:43 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