H
hds
Hi, I'm trying to make a chart that depends on dynamic named ranges.
I've got the dynamic ranges figured out (I think) -- but I'm having
trouble getting the Names recognized. I can create them but they don't
show up in the Names Drop-Down list. As a consequence, the names aren't
recognized in chart source data references. Help!
Here's what happens.
1) I use the Insert > Name > Define tool to create my dynamic ranges.
I think this part is OK. For example:
CensusDataLabels
=OFFSET('Census'!$B$7,COUNTIF('Census'!$B$7:$B$40,"=q*")-1,0,-16,1)
If I click inside the above formula, Excel selects the correct cells,
so I think the formula is OK. The problem is the next step.
2) If I OK the Insert Name dialog and go back to my worksheet, none of
my new ranges appear in the Names drop-down list. If I go back to my
Insert Name dialog, all of my ranges are still there.
So I tried a different method of creating names. If I create a simple
one directly in the worksheet (select cells in sheet, then click in
Names box and type new Name) -- then the new Name does show up in the
Names Drop-Down. So far so good. If I open the Insert> Name> Define
dialog, then my new Name is there. Cool! So I tried to edit my new
Name. I left the title alone and just changed the reference. All
seemed well... but if I go back to my worksheet, the new Name is gone,
no longer in the Drop-Down.
So- any tips as to why my names won't show up in the Names drop-down
box? I've tried this in two different workbooks with the same problem
and I'm stumped. Any help would be most appreciated!
I've got the dynamic ranges figured out (I think) -- but I'm having
trouble getting the Names recognized. I can create them but they don't
show up in the Names Drop-Down list. As a consequence, the names aren't
recognized in chart source data references. Help!
Here's what happens.
1) I use the Insert > Name > Define tool to create my dynamic ranges.
I think this part is OK. For example:
CensusDataLabels
=OFFSET('Census'!$B$7,COUNTIF('Census'!$B$7:$B$40,"=q*")-1,0,-16,1)
If I click inside the above formula, Excel selects the correct cells,
so I think the formula is OK. The problem is the next step.
2) If I OK the Insert Name dialog and go back to my worksheet, none of
my new ranges appear in the Names drop-down list. If I go back to my
Insert Name dialog, all of my ranges are still there.
So I tried a different method of creating names. If I create a simple
one directly in the worksheet (select cells in sheet, then click in
Names box and type new Name) -- then the new Name does show up in the
Names Drop-Down. So far so good. If I open the Insert> Name> Define
dialog, then my new Name is there. Cool! So I tried to edit my new
Name. I left the title alone and just changed the reference. All
seemed well... but if I go back to my worksheet, the new Name is gone,
no longer in the Drop-Down.
So- any tips as to why my names won't show up in the Names drop-down
box? I've tried this in two different workbooks with the same problem
and I'm stumped. Any help would be most appreciated!