How can you switch the rows and columns of a chart using what section of the Chart Tools Design tab?

It is done when you select the data. This is in the data source options, on the Data group. It can also be done as you are going through the chart wizard.