Dynamic chart legends

[anton]

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

 

[Jon Peltier]

The legend is linked to the cell that contains the title of the series, if
you've set up the data properly. By default, Excel tries to use the first
row (or column) of the data range as the series labels, and the first column
(or row) as the category (X) values. This parsing of the data by Excel is
facilitated by leaving the top left cell of the range blank.

If you already have a chart, right click on it and choose Source Data. On
the Series tab of the dialog, select a series, click in the box next to
"Name", and select the cell. Now put in the cell a formula that updates when
you change conditions in the worksheet.

- Jon