series name change

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 !!
Thanks
Daniel

On Tue, 14 Aug 2007, in microsoft.public.excel.charting,
Daniel <Daniel@discussions.microsoft.com> 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 del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.