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.
