Dynamically Label Excel Chart Series Lines My Online Training Hub
Select your chart in Excel, and click Design > Select Data Click on the legend name you want to change in the Select Data Source dialog box, and click Edit Type a legend name into the Series name text box, and click OKRightclick on the empty chart and choose " Select Data " from the contextual menu In the Select Data Source dialog window, click " Add " In the Edit Series box, create a new data series Under " Series name ," highlight the corresponding header row cell ( B1 )