Question

How can you determine which cell data is being used in a chart?

Answer 1

Answer:

Select data for a 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.