Plot data series from worksheet rows or columns

After you create a chart, you can easily change the way that worksheet rows and columns are plotted in the chart.

1. Click the chart that contains the data that you want to plot differently.

   Tip This displays the chart tools, adding the Design, Layout, and Format tabs.

2. On the Design tab, in the Data group, click Switch Row/Column.

   

   Note Clicking this button quickly switches between plotting the data series in the chart from worksheet rows or from columns.

See also:

• Create a chart
• Display hidden data and empty cells in a chart