When you want to see how each part of a data set relates to the whole you would select what type of chart?

To create a chart, you need to select at least one cell in a range of data (a set of cells). Do one of the following:

  • If your chart data is in a continuous range of cells, select any cell in that range. Your chart will include all the data in the range.

  • If your data isn't in a continuous range, select nonadjacent cells or ranges. Just make sure your selection forms a rectangle.

Tip: If you don't want to include specific rows or columns of data in a chart, you can simply hide them on the worksheet, or you can apply chart filters to show the data points you want after you create the chart.

Arrange data for charts

Excel can recommend charts for you. The charts it suggests depend on how you’ve arranged the data in your worksheet. You also may have your own charts in mind. Either way, this table lists the best ways to arrange your data for a given chart.

For this chart

Arrange the data

Column, bar, line, area, surface, or radar chart

Learn more abut

column,

bar,

line,

area,

surface,

and radar charts.

In columns or rows.

When you want to see how each part of a data set relates to the whole you would select what type of chart?

When you want to see how each part of a data set relates to the whole you would select what type of chart?

Pie chart

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

Learn more about

pie charts.

In one column or row, and one column or row of labels.

When you want to see how each part of a data set relates to the whole you would select what type of chart?

Doughnut chart

This chart can use one or more data series.

Learn more about

doughnut charts.

In one or multiple columns or rows of data, and one column or row of labels.

When you want to see how each part of a data set relates to the whole you would select what type of chart?

XY (scatter) or bubble chart

Learn more about

XY (scatter) charts

and bubble charts.

In columns, placing your x values in the first column and your y values in the next column.

When you want to see how each part of a data set relates to the whole you would select what type of chart?

For bubble charts, add a third column to specify the size of the bubbles it shows, to represent the data points in the data series.

When you want to see how each part of a data set relates to the whole you would select what type of chart?

Stock chart

Learn more about

stock charts.

In columns or rows, using a combination of opening, high, low, and closing values, plus names or dates as labels in the right order.

When you want to see how each part of a data set relates to the whole you would select what type of chart?

See Also

Create a chart

Available chart types

Add a data series to your chart

Add or remove a secondary axis in a chart in Excel

Change the data series in a chart

To create a chart in Excel for the web, 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:

When you want to see how each part of a data set relates to the whole you would select what type of 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:

When you want to see how each part of a data set relates to the whole you would select what type of chart?

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:

When you want to see how each part of a data set relates to the whole you would select what type of chart?

Scatter chart

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

When you want to see how each part of a data set relates to the whole you would select what type of chart?

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

What charts represent data as parts of a whole?

Fractions represent equal parts of a whole or a collection.
Series are sets of related data. A chart can have one or more series. Each chart type displays series differently.

What type of graph is used for data?

If you have nominal data, use bar charts or histograms if your data is discrete, or line/ area charts if it is continuous. If you want to show the relationship between values in your dataset, use a scatter plot, bubble chart, or line charts.

Which types of graphs are used to show parts of an entire set of data?

A pie graph (sometimes called a pie chart) is used to show how an overall total is divided into parts. A circle represents a group as a whole.