in a cell (Z100) put
=index(A2:G2,1,S4,1)
Change G2 to whatever you need
Select the graph title block and in the formula section enter =Z100
(or whatever cell you want to use.

"z.entropic" wrote:

> In a worksheet with an embedded chart, I have a cell, S4, where I enter the
> number of the column I want to chart (these numbers are listed as labels in
> cells A2:R2).
>
> I can't figure out how to translate the number in S4 into the corresponding
> column letter. For example, if S4 contains "3", the chart title should be
> =$C$2.
>
> I think working with absolute references, R1C1, might be easier here, but
> somehow what I've tried, didn't work (the entire spreadsheet is based on
> relative addresses (A1).
>
> z.entropic