Linking a chart to a dynamic named range?

rca

Board Regular
Joined
Mar 1, 2005
Messages
182
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 :biggrin:
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,118,436
Messages
5,572,090
Members
412,441
Latest member
kelethymos
Top