Question

can charts in data series can be selected only for rows​

Answer 1

Answer:

Do one of the following: If your chart data is in a continuous range of cells, select any cell in that range.

...

Arrange data for charts.

For this chart Arrange the data

Pie chart This chart uses one set of values (called a data series). In one column or row, and one column or row of labels, like this

Answer 2

Answer:

yes charts in data series can be selected only for rows