How to exchange abscissa and ordinate when EXCEL makes tables?

Making charts in EXCEL and changing the abscissa and ordinate can be adjusted in icon design.

The method comprises the following steps:

1. Open the EXCEL table to be operated, click the chart, and "Chart Tool" will appear in the toolbar, and click "Design".

2. Locate the data item and click Switch Row/Column.

3. Back to the EXCEL table, I found that the abscissa and ordinate of the column chart have been changed.