+ Reply to Thread
Results 1 to 4 of 4

Creating a Chart with Dynamic Inputs

  1. #1
    Forum Contributor
    Join Date
    02-01-2019
    Location
    Illinois
    MS-Off Ver
    2016
    Posts
    223

    Creating a Chart with Dynamic Inputs

    I want to create a graph with two lines and a common, horizontal axis. I only know roughly how many points will be in the graph, so I want to use a dynamic input.

    I created three dynamic, named ranges to hold the data. I inserted a chart. So far, so good.

    The problem came when I tried to enter the named ranges for the data source. I typed the following text into the field:
    UntitledII.png
    but when I clicked 'OK', I got the following error message:
    Untitled.png

    What am I doing wrong and how do I fix it?

    The Excel file is attached.
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Creating a Chart with Dynamic Inputs

    The main problem was with the definition of Horizontal_Axis. You were doing a COUNT on non-numeric data, so it came out as zero. Change this to a CountA and you're in business.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    02-01-2019
    Location
    Illinois
    MS-Off Ver
    2016
    Posts
    223

    Re: Creating a Chart with Dynamic Inputs

    Face Palm!

    Thank you very much.
    Last edited by lovecolorado; 05-21-2019 at 05:19 PM.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Creating a Chart with Dynamic Inputs

    Been there, done that. Usually at least once a week if not more.

+ 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. [SOLVED] Creating a Dynamic List for Chart
    By lovecolorado in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-21-2019, 05:31 PM
  2. Creating a dynamic chart control
    By EchoPassenger in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-01-2016, 03:16 PM
  3. Creating a Dynamic Chart
    By Tulsip in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-20-2016, 02:37 AM
  4. [SOLVED] Creating a dynamic area chart
    By VBANovice46 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-03-2015, 05:40 PM
  5. [SOLVED] Dynamic chart - Show last 3 data inputs
    By Kartoffelmos in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-20-2014, 05:31 AM
  6. Creating dynamic userform based on several file names and creating chart overlays
    By Thorn23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2014, 12:09 PM
  7. Creating a Dynamic Bar Chart in Excel
    By taporctv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2007, 02:49 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