You can tell whether data series are from rows or columns by looking at the row headings and column headings on the datasheet. A graphic that represents the chart type appears in the heading of a row or column.
-
To have the columns on the datasheet represent the data series in the chart, click By Column
on the Standard toolbar.
-
To have the rows on the datasheet represent the data series in the chart, click By Row
on the Standard toolbar.