Enter the new data series in the cells next to or below the source data. If there are no empty cells, insert a new row by right-clicking the row below where you want to insert the new row.

To enter the series 1, 2, 3, and so on as we did earlier, type 1 into a cell. Click in this cell, click the Home tab on the Ribbon toolbar, and click Fill, Series.

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

Launch Excel. Enter data into the spreadsheet or use an existing one. Right-click any of the bars in the chart and select Format Data Series. Click the Fill and Line tab.