how to make a pie chart in excel using select data

We have a table from Range “A6 to B11”, which is having Zone & Sold unit with total sold unit. This pie chart contains the three type of charts in which 1st is 2D Pie Chart, 2 nd is 3D Pie chart and 3 rd is Doughnut Pie chart. Use it when numbers are equal to 100% and the chart contains only few pie slices (many slices make the angels hard to estimate). Pie Chart: - This chart is used to show the proportion of the whole. If the linked chart isn’t open when the chart is updated in Excel, I open PowerPoint, select the chart, click the CHART TOOLS DESIGN tab, and click Refresh Data, which updates the chart.įor more information, see the course summary, and experiment some more with PowerPoint.In this article, we will learn how we can prepare a Pie chart in Microsoft Excel 2010. If I have the linked copy of the chart open in PowerPoint, it updates automatically. Sandoval’s portion in the chart expands to 13% and the other percentages adjust accordingly. I’ll click the cell, type the new amount of $1220, and press Enter. The light background sets off the chart and I like the legend placed at the bottom.īack in the original Excel chart, let’s say I update the chart. Next, let’s click the CHART TOOLS DESIGN tab, and in Chart Styles, point to other possible styles for the chart. To position the chart, I’ll point to an edge and drag the four-pointed arrow cursor, eyeballing the placement for now. We can click X to close the Format Chart Area pane. Then, for Scale Height, I’ll increase the percentage to 200, and press Enter. In the Size group, I’ll click the Size and Position arrow, and I’ll check Lock aspect ratio.

To make it larger, I’ll leave it selected and click the CHART TOOLS FORMAT tab. Now, let’s adapt the chart to the presentation. I’ll choose the third option, Use Destination Theme & Link Data, which pastes and links the chart. The second two options link the chart, either using the destination theme or keeping the source formatting. The first two will embed the chart, either using the destination theme or keeping the source formatting. In PowerPoint, display the destination slide and right-click it. To copy and link the chart, right-click it, and click Copy to copy it to the Clipboard. When you keep a link to the chart, your updates to it are reflected in the PowerPoint version. If you prefer creating charts in Excel, create your pie chart there and copy it into PowerPoint.

How to make a pie chart in excel using select data