Linking a chart to a dynamic named range?

[rca]

Hi Everyone,

I have a dynamic range named "myRange". This range currently has about 140 values in it. I would like to chart this range.

Is it possible to link the chart to this dynamic range so that the CHART AUTOMATICALLY UPDATES when the size of the range increases (without having to manually update the chart)?

I tried to do this in the 'Source Data' dialogue box. In the 'Series' tab, I tried to type "myRange" into the 'Values' field... but, it would not accept it.

I get an error message saying "the formula you typed contains an error..."

Does anyone know how to do this?

Thanks,
Rachel

 

[tusharm]

Assuming you've defined the dynamic range so that it returns a reference that is acceptable to the charting module, see
Names in Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/names_in_charts.html

For more on dynamic charts see
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

 

[rca]

Thank you Tushar!!!

 

[tusharm]

You are welcome.