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.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×