+ Reply to Thread
Results 1 to 1 of 1

Trouble with Fixed Chart Series Data Range when adding Rows

  1. #1
    Registered User
    Join Date
    10-30-2014
    Location
    MO
    MS-Off Ver
    2010
    Posts
    6

    Trouble with Fixed Chart Series Data Range when adding Rows

    I have a worksheet that contains a macro to add a new row (with data pulled from other places of the workbook; not included in this example workbook) at line 62. There are charts above this data, and I want the chart to always graph data from rows 62-71.

    I've tried using named ranges with the indirect function (I'd have column letter and numbers 62 and 71 typed in different cells and use something like =INDIRECT(Report!U8&Report!U9&":"&Report!Y8&Report!Y10) as the "Refers to" in the Name Manager. This formula always messes up for some reason after I add the row (e.g. U8 will change to S8 or something of the sort).

    I've tried using the index function instead of the indirect function in the name manager; for example, =Index(B62:B71,1):INDEX(B62:B71,10), but when I add rows with the macro button, the formula in the name manager changes as well.

    What can I do to make the chart range stay the same when I add rows with the macro button?
    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. Replies: 2
    Last Post: 10-30-2014, 05:48 PM
  2. Need help, adding data series to existing chart using SeriesCollection.Add Method?
    By ath1337 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2012, 05:29 PM
  3. Pie Chart - Adding 2nd data label series?
    By Bjornago in forum Excel General
    Replies: 6
    Last Post: 01-19-2010, 08:39 PM
  4. [SOLVED] How do I pass series data x-value range to a chart from a cell?
    By Ian in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-03-2006, 12:15 PM
  5. Adding data series to chart via macro
    By JessK in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-01-2006, 07:10 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