Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
series titles
I have excel 2007 how do you rename from series 1,2, ect to a name I need?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
series titles
I find the easiest way to be changing the series formula. Select the series,
and in the formula bar is a formula that looks like this: =SERIES([name],[x values],[y values],[plot order]) The [name] part can be blank, resulting in Series 1, Series 2 names, or text enclosed in quotes, or a link to a cell. =SERIES(,Sheet1!$D$4:$D$10,Sheet1!$E$4:$E$10,1) =SERIES("The Series",Sheet1!$D$4:$D$10,Sheet1!$E$4:$E$10,1) =SERIES(Sheet1!$E$3,Sheet1!$D$4:$D$10,Sheet1!$E$4: $E$10,1) If you want to use a dialog approach in Excel 2007: Chart Tools Design tab Select Data Select the series in the Select Data Source dialog, click the Edit button, and in the Series Name box, type what you want (no need for quotes, Excel fills them in when you click OK), or with the cursor in the Series Name box, click on the cell with the series name text. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dips1" wrote in message ... I have excel 2007 how do you rename from series 1,2, ect to a name I need? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to plot column chart with one series against multiple series. | Charts and Charting in Excel | |||
Changing series information for approximately 60 series in a workb | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel | |||
series graph -- one series being added to another series | Charts and Charting in Excel |