how to make a pie chart in excel with two column of data

The values in the columns will define the size of the pie slices. At least one column containing numeric values.In our case, the three categories are: 'bottom 50%', 'next 40%' and 'top 10%'' One column containing at least two categories. This will determine the label in the pie slices.One header row containing descriptive labels.

If you want to create this chart type, here's what you'll need: We can see the shares of three countries' wealth that the bottom 50%, the next 40% and the top 10% of citizens own: If you want to show more than five parts per pie, consider grouping them as a stacked bar chart.īelow is an example of a multiple pies chart that makes good use of the part of the whole concept. The individual pies should not have too many slices as this clutters the chart and makes it hard to read. To see a menu of all available chart types in newer versions of Excel, click the down arrow by 'Charts' in the Charts section of the ribbon's Insert Tab.A multiple pies chart is useful when you want to show proportional parts of multiple wholes and to give the reader an extra data point in the middle. Other Chart TypesĮxcel offers other charts such as Stock, Surface, Doughnut, Bubble, and Radar.

The series pair has a Positive Correlation if they increase similarly, and a Negative Correlation if they both decrease in like manner. See Scatter Charts with Lines to understand why this happens and how to fix it.

Sometimes scatter charts with lines can be confusing if the line zig-zags and crosses itself. See Microsoft Excel: The Scatter Chart for more information. In general, markers work well when the number of data points is small, and smooth lines are often used with a large number of data points. Scatter charts come with or without markers, and data points can be connected with smooth or straight lines. The scatter chart is called the XY Chart because its data points are the intersection of two values on the X and Y-axis. The scatter chart observes the relationship between two variables.

How to make a pie chart in excel with two column of data