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.

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.

Click the Edit button. Enter the new name in the Series name box. Enter the Series values if required. Click the OK button. Open up the Excel spreadsheet where you can find the desired chart.

The current set of input cells begins the series at 8:00 a.m. and increments each value by two hours and 30 minutes. Don’t forget to change the format if you want the time values to display seconds.