Creating a Dynamic Graph Using Text Cell References

**Andy Pope** · 04-01-2013, 11:16 AM

Named range xCHT_DATA
=INDEX(INDIRECT(References!$K$4),1,1):INDEX(INDIRECT(References!$L$4),1,1)

You will need to add additional single quote to start of cell otherwise it will be ignored.

K4: ''Suburban (By District)'!$K$2
L4: ''Suburban (By District)'!$U$2

**derekjwilson** · 04-01-2013, 11:48 AM

Hi Andy,

Thanks for the help. A quick question - how do I add the additional quotation mark? The text string is generated by a formula, so if I enter it, the cell turns the formula into a string.

The formula is:

=IF(VLOOKUP(Settings!$G$6,$B$2:$D$39,3, FALSE)="C","Suburban (By Class)","Suburban (By District)")

**Andy Pope** · 04-01-2013, 11:52 AM

Something like this

=IF(VLOOKUP(Settings!$G$6,$B$2:$D$39,3, FALSE)="C","''Suburban (By Class)","''Suburban (By District)")

Although your formula has no single quotes so I don't know where they are coming from in the first place.

**derekjwilson** · 04-01-2013, 12:45 PM

Ok - so this is what I am doing.

=IF(VLOOKUP(Settings!$G$6,$B$2:$D$39,3, FALSE)="C","'Suburban (By Class)","'Suburban (By District)")

[Result] >>> 'Suburban (By District)

=ADDRESS(I4,$I$21,,,$J$2) (J2 is the previous result)

'''Suburban (By District)'!$K$2

For some reason, when I add in the extra ' in the first formula, the second formula outputs three 's - one that it did already, and another from who knows where.

Essentially, 1 + 1 = 3.

No matter what I try, I always get ', or ''', or '''', but never '' - which is apparently what I need.

Thoughts?