Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
series name change
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change transparency of series | Charts and Charting in Excel | |||
Change individual series from bar to line | Charts and Charting in Excel | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
Change series in a chart | Charts and Charting in Excel | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel |