Defining name

  • Thread starter Thread starter howiechc
  • Start date Start date
H

howiechc

I have created a variable/name to parse in a value and it works b
calling :

=INDIRECT("["& indo &"]Calculation!$F$5:$F$14")

with "indo" being the variable/name.

But it is not possible when I tried this in creating a chart. I need t
call the variable/name in the data range field but the field can'
inteprete them well.

Have any idea how to work it out?

Please help and thanks in advance! Cheers.

Howie C.
http://www.digiwerkz.co
 
Howie,

I haven't tried this in this context, but you can usually create a defined
name (Insert - Name - Define). In the "refers to" box, build your
expression. Then in the chart source data, use the name.
 
Hi
what is your exact problem. Normally you can use dependent names in
charts (Though I use OFFSET functions for this). Some ideas:
1. Is the other workbook open? - If not INDIRECT won't work
2. How is indo defined?
 
Back
Top