Select data for a chart

To create a chart in Excel Online, you need to select at least one cell in a range of data (a set of cells). Your chart will include all data in that range.

Arrange data for charts

This table lists the best ways to arrange your data for a given chart.

For this chart

Arrange the data

Column, bar, line, area, or radar chart

In columns or rows, like this:

Data arrangement for a column, bar, line, area, or radar chart

Pie chart

This chart uses one set of values (called a data series).

In one column or row, and one column or row of labels, like this:

Table with 2 columns, 3 rows; Table with 3 columns, 2 rows

Doughnut chart

This chart can use one or more data series

In multiple columns or rows of data, and one column or row of labels, like this:

Table with 3 columns, 3 rows; Table with 3 columns, 3 rows

Scatter chart

In columns, placing your x values in the first column and your y values in the next column, like this:

Data arrangement for a scatter chart

For more information about any of these charts, see Available chart types.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×