Changing Series Name Right click on the graph;Formatting 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 panelNote You will see the Series (Product A and Product B), which correlate to the legend on the graph 3 For each Series, Click Edit Note You can see right now it is linked to a current cell Right now, it is linked to "Product A" 4 You can change this formula and link it to another cell
Change Series Formula Improved Routines Peltier Tech