naming series with combination of cell references

[Eanna]

Hi,
I would be very grateful for help with the following:
I have cells with parameters for a function I am plotting with a
different series for each combination of parameters.
The parameter name and corresponding value are in different cells as
follows
Col1 Col2
Row1 a 10
Row2 b 20

I would like the series to be named according to a combination of the
parameter name and value as follows:
a=10, b=20

I would like this series name to update if either the parameter name or
value is changed.

How do I include a cell reference in the series name with a combination
of text?
=Row1Col1 +"=" +Row1Col2 +","+ etc

Thanks in advance,
Eanna

 

[Don Guillett]

For a formula, have a look at help index for INDIRECT

For a macro
mycell=range("a2")

 

[Eanna]

My problem was using '+' instead of '&' to concatenate cells. THe
solution I found is:
="A=" & D1 & ",C=" & D2 & ", M=" & D3 & ", B=" & D4 & ", T=" & D5

Eanna