Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Lawrence, Kansas, USA
    Thanked 0 Times in 0 Posts

    Dynamic Chart Range (2003 SP2)

    I want my charts to update automatically. When I enter the following range, I get all of the data, but it doesn't update when I add new data. I'm not sure how to make this happen.

    =$G$1:INDEX($M:$M,MATCH(9.99999999999+307,Returns! $M:$M))

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Dynamic Chart Range (2003 SP2)

    You have to create dynamic named ranges for the Y values of each of the series. So if you have 7 series, you need to create 7 named ranges. If you have labels for the X values, you must also create a dynamic named range for them. See Create a Dynamic Chart or How to use defined names to automatically update a chart range in Excel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts