+ Reply to Thread
Results 1 to 4 of 4

Dynamic Chart - Changes Defined Name to Range after clicking OK???

  1. #1
    Registered User
    Join Date
    01-18-2015
    Location
    Michigan City, Indiana
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Dynamic Chart - Changes Defined Name to Range after clicking OK???

    I am plotting multiple series as a function of one variable. I defined a dynamic range with the defined name of _CurveX in the formulas tab with a reference of OFFSET('Curves X'!$B$3,0,0,180,'Vertex (2)'!$R$3+2). This works fine when I enter this into the Chart Data Range: ='Curves X'!_CurveX, but after I hit OK it removes the 'Curves X'!_CurveX and replaces it with ='Curves X'!$B$3:$L$182 which is not dynamic anymore....

    Dynamic Chart.jpg

    I basically want to plot the vertices as a function of the angle. But, I have an large number of vertices and I only want the plot a few vertices so I defined a dynamic ranges that depends on an input 'Vertex (2)'!$R$3+2.

    Why is it replacing 'Curves X'!_CurveX with 'Curves X'!$B$3:$L$182 after I click ok, and is there a better way of doing this???

    Thanks everyone

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

    Re: Dynamic Chart - Changes Defined Name to Range after clicking OK???

    If you enter the formula into the Chart Data Range it will be converted to range references.

    Instead you need to use the Select Data dialog. Add a series and enter the named range reference to the Series Name box.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-18-2015
    Location
    Michigan City, Indiana
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Re: Dynamic Chart - Changes Defined Name to Range after clicking OK???

    Thanks, but that was what I was trying to avoid. I want to dynamically create a chart that could increase in the number of data points in a column, but also increase in the number of series as well without having to add each series individually to the charts.

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

    Re: Dynamic Chart - Changes Defined Name to Range after clicking OK???

    unfortunately it does not work like that.

    named ranges are used to alter start and length of a single series

+ 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. Sumif's across multiple sheets defined by a dynamic range.
    By Kramxel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-19-2014, 12:55 PM
  2. How to set MyRange if i have dynamic range for dynamic chart
    By Dbmaryleo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2012, 05:00 AM
  3. Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007)
    By BrokenBiker in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2012, 11:40 AM
  4. [SOLVED] Dynamic Chart Formatting Based on Defined Column
    By TEBrown in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-18-2012, 06:47 PM
  5. [SOLVED] dynamic range defined in VBA for use in formulas
    By yo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2005, 02:06 PM

Tags for this Thread

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