You can manually name the series, using the Select Data command from the ribbon or from the right click menu, or editing the series formula But it's not too much trouble to write a little code to find the appropriate cells to name the series in a chart I'll start with a routing that works on one chart seriesFormatting a Series Title To change the Series 1 text on the Chart heading to something more descriptive, select the title as you did above Make sure the circles are there, and then right click You should see the following menu appear in Excel 07 Click on "Edit data source" Alternatively, click the Edit data source item on the Data panel Select the series you want to edit, then click Edit to open the Edit Series dialog box Type the new series label in the Series name textbox, then click OK Switch the data rows and columns – Sometimes a different style of chart requires a different layout of the information Our default line chart makes it difficult to see how each state
How To Edit Series Formulas Peltier Tech