The Color-Coded Ranges Method

THE COLOR-CODED RANGES METHOD (FOR EMBEDDED CHARTS ONLY) 

To extend the range of all existing series, drag either of the handles down, as 

This method can be used only for embedded charts with data in adjacent ranges of cells. A chart with data in non-adjacent ranges does not display color-coded ranges when you click on the plot area. 

To operate on a single data series, click on the series. The color-coded range of X values and a single color-coded range of y values will be displayed. To extend the data series, you have to drag the handle for the x values (the purple handle) down, then repeat for the y values. You can t add a new data series by dragging the y values handle (the blue handle) to the right. 

---