Dynamic Chart Range (2003 SP2)

Topic

New Reply

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))

Reply | Quote

Replies

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.

Reply | Quote