Create dynamic Formula using Indirect

Hi any one,

i want to update my chart with dynamic Range. Here i am using two different series for a single chart, for that i reffered each range as using dynamic range, each Named Range contains indirect function for reffering address. but my chart wont accept rather it clears all the chart series.

can any one tell me please, how to use indirect in named Range and also used the same range in chart...


Thanks in advance....

Well, you're certainly on the right track! :)

There's just a trick one has to know about - you have to prefix the named ranges by the workbook name, otherwise the chart won't accept them. So, if I have a range "myRange" in workbook "myBook", this won't work
Values: =myRange
but this will
Values: =myBook!myRange
It's not something one could easily guess at - but a simple google search for
|excel "named range" chart series values|
produced more than five good hits on the first page alone. ;)

See if either of these links show you somethin new :)

http://office.microsoft.com/en-us/excel/HA011098011033.aspx
http://www.ozgrid.com/Excel/DynamicRanges.htm