Then, click the first pie option, at the top left. On the Excel Ribbon, click the Insert tab. Insert the ChartĪfter your data is set up, follow these steps to insert a pie chart: We could create a pie chart from either set of numbers. In rows 9 and 10, the data is arranged horizontally, with numbers in a single row. At the top, the data is arranged vertically, with numbers in a single column. In the screen shot below, you can see two sets of data showing sales per region. I’d pick 6 as the upper limit, but let your conscience (or your boss) be your guide. 
Warning – Only use a few numbers, or the pie chart won’t be readable.
(optional) heading cells for the numbers and text. (optional) one row or column with text that describes the numbers. What should your data look like, if you want to build a pie chart? It should have the following: Then, make a few changes to the chart setup, so it's easy to read and understand. Here are the steps for setting up the data, and creating a pie chart. How to Build a Pie Chart How to Add Pictures to Pie Chart Slices How to Build a Pie ChartĪ pie chart is a circle with one or more slices, and each slice is sized to show its share of the overall total amount. 
How to add pictures to the pie chart slices.How to build a simple pie chart in Excel.You can even get fancy, and add pictures to the pie chart slices. A pie chart is a circle with one or more slices, and each slice is sized to show its share of the overall total amount.
0 kommentar(er)
