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 ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
