Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you show the image, Where you are trying this
in the definition of a chart expression
doing the same with RowNo() works fine.