series titles
I have excel 2007 how do you rename from series 1,2, ect to a name I need?
|
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? |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com