Pie charts are great for showing both a value and a proportion for each category. The way in which data is presented by a pie chart makes it very easy to make comparisons quickly. That allows viewers to analyze the data in a snap. A box plot, for example, might leave audiences scratching their heads.
But nearly everyone knows how to read a pie chart. That makes it easier for you to present and for them to interpret. There are many different kinds of pie charts, and they each have distinct visual advantages. For example, if you have multiple values per category, a clustered column or bar chart will better serve your purposes. And if you want to show change over time, a line chart is probably your best bet. Just make sure that your categories and associated values are each on separate lines :.
Excel can interpret both formats. Then click to the Insert tab on the Ribbon. If you forget which button is which, hover over each one, and Excel will tell you which type of chart it is. When you first create a pie chart, Excel will use the default colors and design. Mouse over them to see a preview:.
One of the ways you can customize your chart is by picking a new color scheme. Use the Change Colors dropdown to select a new one:.
To change the colors and styles of individual elements, head to the Format tab in the Chart Tools section of the Ribbon:. You can also change the layout with the Quick Layout menu. The presets in this menu have elements like percentage labels, value labels, and differently located legends:. You can also add and remove individual elements with the Add Chart Element menu. Just deselect them to make them disappear. If you selected the wrong data for your pie chart, or you added new data to your spreadsheet, you can adjust the selection with the Select Data dialog, accessed from the Ribbon:.
You can type in the Chart data range box or simply click-and-drag to identify the new selection. The pie chart is commonly used, and for good reason. It presents data efficiently, shows both values and proportions, and is very easy to read. If you're using an earlier Office version your experience might be slightly different, but the steps will be the same.
In your spreadsheet, select the data to use for your pie chart. For more information about how pie chart data should be arranged, see Data for pie charts. To show, hide, or format things like axis titles or data labels , click Chart Elements. To quickly change the color or style of the chart , use the Chart Styles. To show or hide data in your chart click Chart Filters.
Tip: You can draw attention to individual slices of the pie chart by dragging them out. Note: If your screen size is reduced, the Chart button may appear smaller:. For more information about how to arrange pie chart data, see Data for pie charts. To arrange the chart and text in your document, click the Layout Options button.
Pie charts can convert one column or row of spreadsheet data into a pie chart. Each slice of pie data point shows the size or percentage of that slice relative to the whole pie.
You have no more than seven categories, because more than seven slices can make a chart hard to read. In addition to 3-D pie charts, you can create a pie of pie or bar of pie chart. These charts show smaller values pulled out into a secondary pie or stacked bar chart, which makes them easier to distinguish.
To switch to one of these pie charts, click the chart, and then on the Chart Tools Design tab, click Change Chart Type. When the Change Chart Type gallery opens, pick the one you want. Select data for a chart in Excel. Create a chart in Excel. Add a chart to your document in Word. Add a chart to your PowerPoint presentation. Available chart types in Office. Import and analyze data. Need more help? Expand your skills.
0コメント