+ Reply to Thread
Results 1 to 4 of 4

Excel not plotting dynamic ranges

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2013
    Posts
    22

    Excel not plotting dynamic ranges

    I am trying to plot dynamic data from named ranges, but nothing generates on my graphs.

    Named Range.PNG

    When I select the data for my graph, it displays the horizontal axis labels, so I know that it is pulling the data from the named ranges, but it will not generate a plot.

    Graph.PNG

    I am not sure what the problem is, and any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by acmichae; 07-01-2019 at 10:29 AM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,814

    Re: Excel not plotting dynamic ranges

    Difficult to debug from a screenshot. Can you upload a sample file to the forum?

    What chart type are you working with? It looks like a scatter chart, and it looks like it is correctly reading the X values for at least one of the data series. What is it trying to use for the Y values? What should it be using?

    If I were to debug this, the first thing I would probably do is pull up the Select data dialog like you show in the second screenshot. Select one of the data series and click on the Edit button and see what it is using for both X and Y values. I would be tempted to pull up the change chart type and make sure I am using the marker and line subtype of the scatter chart, so that I know I will be able to see something when a point shows up on the chart. I might also bring up the format axis dialog for each axis and set the max and min limits to auto.

    See where that gets you.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Excel not plotting dynamic ranges

    I have attached an example sheet of my plotting problems. As you can see by the table and plots, I have a named range for each column, which is dynamic data that is based on data from a different workbook. I did not include this data manipulation in this example sheet. If I reset the x-axis boundaries, the plot shows up, but the x-axis values are not accurate?

    Attachment 630429

  4. #4
    Registered User
    Join Date
    11-15-2012
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Excel not plotting dynamic ranges

    I solved my issue by adding VBA code that converts the data in Column D to numbers.

+ 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] Inserting Formula into Excel for dynamic Ranges
    By chrixton in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-27-2014, 11:43 AM
  2. [SOLVED] Setting up Dynamic Ranges from Cells (Excel 14, VBA Only)
    By lloydgodin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-14-2012, 12:46 PM
  3. Software for FAST plotting charts from dynamic excel data?
    By naira in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-26-2012, 01:48 PM
  4. [SOLVED] Dynamic Ranges [Excel VBA 2010]
    By lloydgodin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2012, 05:55 PM
  5. Using Dynamic Ranges for Excel Charts
    By sriaknt1983 in forum Excel General
    Replies: 15
    Last Post: 03-29-2011, 07:20 AM
  6. Excel 2007 : Plotting Date Ranges on Same Graph
    By jwig in forum Excel General
    Replies: 0
    Last Post: 04-06-2009, 08:29 PM
  7. plotting a Dynamic Graph...
    By tomsmart27 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-21-2008, 04:13 PM
  8. Excel:DYNAMIC RANGES
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2005, 02: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