Excel® 2013 On Demand

Adding and Deleting a Data Series

Many components make up a chart. Each range of data that comprises a bar, column, or pie slice is called a data series; each value in a data series is called a data point. The data series is defined when you select a range on a worksheet and then open the Chart Wizard. But what if you want to add a data series once a chart is complete? You can add a data series by using the Design tab under Chart Tools, or using the mouse. As you create and modify more charts, you might also find it necessary to show or hide data (New!), or delete or change the order of one or more data series. You can delete a data series without re-creating the chart.

Add a Data Series Quickly

Click the chart you want to modify.

Click the ...