Select the data, including the headings, and click Insert > Charts > Pie, and select a chart type. Don’t worry if you don’t know what this means as it’s just the numbers we’ll be looking at. We’ll use this data to create a pie chart.

Here is a breakdown of the votes for each party in a particular consituency in the UK. Each piece of data is represented as a portion of a whole, so relative sizes are easy to compare. In columns or rows, using a combination of opening, high, low, and closing values, plus names or dates as labels in the right order.Unlike other charts in Microsoft Excel, pie charts require that data in your worksheet be contained in only one row or column (although an additional row or column can be used to indicate a “category”). In columns, placing your x values in the first column and your y values in the next column.įor bubble charts, add a third column to specify the size of the bubbles it shows, to represent the data points in the data series. In one or multiple columns or rows of data, and one column or row of labels. This chart can use one or more data series. In one column or row, and one column or row of labels. This chart uses one set of values (called a data series). Either way, this table lists the best ways to arrange your data for a given chart.Ĭolumn, bar, line, area, surface, or radar chart

You also may have your own charts in mind. The charts it suggests depend on how you’ve arranged the data in your worksheet.

Arrange data for chartsĮxcel can recommend charts for you. 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.

Make a pie chart in excel 2010