+ Reply to Thread
Results 1 to 7 of 7

Graphing Dynamic Arrays

  1. #1
    Registered User
    Join Date
    01-29-2010
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    47

    Graphing Dynamic Arrays

    I am trying to graph some data using a dynamic array. The array updates in size properly but the graph doesn't update with the array.

    When I "select data" I type in:

    Please Login or Register  to view this content.
    I then click ok, and the graph forms exactly how I want it. When I go back in the "select data" area the equation now shows the exact cell references as opposed to the dynamic array name.

    Is there any way to work around this and have the graph maintain the array name?

    Thanks in advance.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,655

    Re: Graphing Dynamic Arrays

    How is the range name defined?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    01-29-2010
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Graphing Dynamic Arrays

    =OFFSET($R$1,0,0,13,$Q$1)

    Where Q1 is a cell that counts the number of columns that are not #N/A errors.

  4. #4
    Registered User
    Join Date
    01-29-2010
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Graphing Dynamic Arrays

    Still having trouble with this. I've searched the forum here and elsewhere online but can't find a solution.

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,191

    Re: Graphing Dynamic Arrays

    I believe that the dynamic range needs to be within the same workbook, otherwise it converts it to a static range. Sorry.
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  6. #6
    Registered User
    Join Date
    01-29-2010
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Graphing Dynamic Arrays

    Quote Originally Posted by ChemistB View Post
    I believe that the dynamic range needs to be within the same workbook, otherwise it converts it to a static range. Sorry.
    It actually is within the same workbook. I only used the workbook reference because that's how it appeared on other graphs. It also wouldn't accept "=Months_fish"

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,736

    Re: Graphing Dynamic Arrays

    If you enter the source data as a named reference the chart will revert to static range reference once the chart is built.

    You need to define the named range parts for the values and category sections of each data series.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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