If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing "Series" Name
When I create a chart with two different line dispays there is a legend at
the right side that says: Series 1 Series 2 How can I change the to say: John Mary ? |
#2
|
|||
|
|||
Jerry,
To add series names to the legend, first click on your chart to activate it. Then, go to the standard toolbar and hit Chart - Source Data - Series Tab. In the Series dialog box you should see a field called "Name". You can add a name for each of your two series in this field. To move between the two series to individually add a name, click on "Series1" or "Series2" on the left side of the dialog box under the "Series" option. Another way to add series names is to add titles above each of your columns before building your chart. For example, using the data below start column 1 in cell A2, column 2 in cell B1, and column 3 in cell C1. Title1 Title2 a 2 3 b 3 4 c 2 3 After the data is entered into the spreadsheet, go to cell A1, activate the Chart Wizard, and go through the prompts. The Chart Wizard should automatically assign "Title1" to series 1 and "Title2" to series 2. ---- Regards, John Mansfield http://www.pdbook.com "jerry chapman" wrote: When I create a chart with two different line dispays there is a legend at the right side that says: Series 1 Series 2 How can I change the to say: John Mary ? |
#3
|
|||
|
|||
Click on the line representing the series you want to name and then click
your right mouse button over it. Choose 'Source data' from the menu and then click on the Series tab at the top of the window. The series you clicked on should be selected in the box on the left of the window and you can type a name for it in the box on the right hand side, select the Series2 on the left when you have done the first series and you can name that as well. Andrea Jones www.allaboutoffice.co.uk "jerry chapman" wrote in message ... When I create a chart with two different line dispays there is a legend at the right side that says: Series 1 Series 2 How can I change the to say: John Mary ? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ineffective change of plot order in series formula | Jon Peltier | Charts and Charting | 3 | May 30th, 2004 02:15 AM |
Hiding some labels on value axes; Changing series names | Leslie | Charts and Charting | 3 | April 28th, 2004 01:21 PM |
Changing a series' Name, X- and Y-values by using its series number | L Mehl | Charts and Charting | 4 | February 4th, 2004 01:32 PM |