On Tue, 14 Aug 2007, in microsoft.public.excel.charting,
Daniel said:

How can I change the name of "series" ?

I added to the chart with straight line by highlight two numeric columns.
I can create lines but the legend show series 3,4,5,6 !!

Choose menu Chart.. Source Data.. Series, and there will be a box for
series name. You can either put the name in directly or vie a cell
reference.

Or, if you select the series on the chart, you should be able to see
series formula in the formula bar above that looks like this:

=SERIES(Sheet1!$D$1,Sheet1!$A$2:$A$18,Sheet1!$D$2: $D$18,3)

You can edit this directly, just like editing a formula in a spreadsheet
cell. The place to write the series name, is just after the open bracket
and before the first comma, like so:

=SERIES("Third series",Sheet1!$A$2:$A$18,Sheet1!$D$2:$D$18,3)

I've written "Third series" in there, with quotes. Alternatively:

=SERIES(Sheet1!$D$1,Sheet1!$A$2:$A$18,Sheet1!$D$2: $D$18,3)

Then the series name will be whatever is in cell D1.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.