Hi,
we're looking for a way to link legend entries of our charts to a given cell
on the same sheet.

For example: we have a series and a factor by which we would like to
multiply this series. Then we plot the multiplied series. When we change the
factor, we want the legend entry for this series to vary accordingly,
something like "factor x Series". So the legend entry should somehow pick up
the value of the cell we use to specify the factor (without using another
cell which concatenates the factor cell and another cell that contains "x
Series").

Your help is much appreciated....
anton