dynamic variable name with columnno() in pivot chart expression

[Anonymous]

Hi,

if I use 'vcalc' & ColumnNo() in a chart expression in a pivot table, I see this in the cells: vcalc1, vcalc2... as text.

Looks good so far.

But I would need to use is as variable names.

I have different variables for each column in a pivot table.

How to convert the text created with 'vcalc' & ColumnNo() into a variable name?

I tried different things like:

=$($(='vcalc' & ColumnNo()))....

but nothing works.

Any idea?

Roland

[Anil_Babu_Samineni]

Can you show the image, Where you are trying this

[Anonymous]

in the definition of a chart expression

[Anonymous]

doing the same with RowNo() works fine.