Advanced Spreadsheets – Add and delete a data series in a chart

In the same way as we can change the chart type for a chart, in case some new data field is added for a chart, we can simply update this in the already existing chart and we do not need to create another one from the beginning.


img0
img1
img2
img3
img4
img5
img6
img7
img8
img9


To add or delete a data series in a chart, first of all select the chart. After this, right-click anywhere on the chart area, and from the resulting menu click on ‘Data Ranges’. This will open the ‘Data Ranges’ dialog box.
Data Ranges 7

In this dialog box, under the ‘Data Series’ tab, we can add or delete a data series by using the ‘Add’ or ‘Remove’ buttons respectively. When a new data series is added, the name and range for that series can be selected from the spreadsheet using the select icons provided in the dialog box. After making all the changes, upon clicking ‘OK’, the new data series will get reflected in the chart.