Change How Rows And Columns Of Data Are Plotted In A Chart

Home » How To Switch Axis In Excel Scatter Plot » Change How Rows And Columns Of Data Are Plotted In A Chart

Maybe your like

How Excel determines how data is plotted in a chart

When you create a chart, Microsoft Office Excel determines the axis on which the data series are plotted, based on the number of worksheet rows and columns that are included in the chart, placing the larger number on the horizontal axis.

If your data has equal rows and columns of worksheet data, Excel plots the rows of data on the vertical axis, and the columns of data on the horizontal axis. After you switch rows to columns in the chart, the columns of data are plotted on the vertical axis, and the rows of data are plotted on the horizontal axis.

However, you can quickly change the way that worksheet rows and columns are plotted in the chart by switching rows to columns or vice versa.

Charts that are plotted by rows and by columns of worksheet data

Top of Page

Tag » How To Switch Axis In Excel Scatter Plot