What is a chart data range on excel
Add a Data Series. If you need to add additional data from the spreadsheet to the chart after it's created, you can adjust the source data area. Select the chart. If your chart data is in a continuous range of cells, select any cell in that range. Your chart will include all the data in the range. If your data isn't in a continuous range, select nonadjacent cells or ranges. Just make sure your selection forms a rectangle.