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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help 2
INDIRECT function 3
INDIRECT and defined named ranges 7
Set non-continuous PrintArea via Function / Name 0
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Pivot table calculated field Count(field) / sum(field) 0
Excel Concatenate Form Name to Parse for function 1
Excel 2010: How to display PivotChart Report Filter Lables on the graph 2

Back
Top