Which action switches the rows and columns in a chart so data series are grouped by year?

Which action switches the rows and columns in a chart so data series are grouped by year?

• A. In the Design ribbon tab you clicked the switch row/column button
• B. Data tab, Sort & Filter group, Transpose
• C. Insert tab, Charts group, Change Chart Type
• D. Home tab, Styles group, Swap Chart

Answer: (A)

Switching rows and columns changes how the chart interprets the data: which parts are treated as data series and which parts serve as category labels. By using the Switch Row/Column command in the Chart Design tab, Excel reorients the data range so that the grouping aligns with year, effectively organizing the chart data by year. This is the tool designed specifically to swap the data’s orientation within the chart. Other options either operate on worksheet data (Transpose), change the chart type, or aren’t standard chart commands, and don’t adjust the row/column orientation used to define series and categories.

Switching rows and columns changes how the chart interprets the data: which parts are treated as data series and which parts serve as category labels. By using the Switch Row/Column command in the Chart Design tab, Excel reorients the data range so that the grouping aligns with year, effectively organizing the chart data by year. This is the tool designed specifically to swap the data’s orientation within the chart. Other options either operate on worksheet data (Transpose), change the chart type, or aren’t standard chart commands, and don’t adjust the row/column orientation used to define series and categories.