Switching Table Rows and Columns for Chart Data Series
When you select a chart, a dark frame appears around its related table cells. The data
series button in the upper-left corner of the frame around the referenced table
of a selected chart lets you transpose the table rows and columns as data series in
These squares indicate
which color represents
each data series.
Data series button
To transpose table rows and columns as chart series:
Select the chart, and then click the data series button.
When the button looks like this, the columns are data series.
Click the button to make rows the data series.
When the button looks like this, the rows are data series.
Click the button to make columns the data series.