Amir created a column chart from a data source that listed the sales for each of three sales reps over the course of six months. He wants the chart to compare the sales of each rep to the sales of the other two reps. But when he created the chart, the months appeared on the horizontal axis instead of the names of the sales reps. What can he do to change the chart so that the names of the sales reps appear on the horizontal axis?
A) Change the chart type.
B) Change the chart layout
C) Use the Switch Row / Column command.
D) Switch the data labels.

Question

Quizplus · Accepted Answer

The Switch Row / Column command in Excel allows you to change which data is displayed on the horizontal and vertical axes of a chart. By using this command, Amir can switch the rows and columns of his data source so that the sales reps' names appear on the horizontal axis instead of the months.

Amir Created a Column Chart from a Data Source That