Show 

Home > Insert > Charts > Chart Design Tab > Switch Row/Column

 

Switch Row/Column

 

Chart Design Tab > Switch Row/Column

Switch the chart row/column data.

You can redraw the selected chart based on row or column data by clicking the Switch Row/Column icon in the Chart Design tab, or from the Edit Chart Data dialog box.

Steps

To switch row/column data

  1. Select a chart you want to switch row/column data.

  2. In the Chart Design tab, click the Switch Row/Column icon.
    The chart redraws the data based on row data.

   In the Chart Design tab, click the Switch Row/Column icon again to put it back.

See Also