Be sure not to select the cells where you totaled things up. This literally means holding down the left mouse button and dragging a box around the data. Select the data that you want to include in the pie chart. You can make it look snazzy by styling it from the Home ribbon, but this won’t affect our pie chart. This is pretty easy, one column is your description of the numbers, and the other column is your numbers. Update: If you are running modern versions of Excel in the Microsoft 365 (formerly O365) subscription suite, read how to make pie charts in Excel.įirst, you’ll need to write your list of data in Excel. This approach obviously would require some experimentation to get exactly the right look, but it is a great approach if the data that underlies the table will change periodically.Make a Pie Chart in Microsoft Excel 2010 or 2007 You can then overlay the five charts to get the desired effect. You format each chart, individually, so that each of them leaves only a single slice visible. Thus, if you have five slices in your pie chart, you would make five charts (one for each slice) that start out exactly the same. Each chart is based on the entire original data table, but you set the colors for the group to be represented by the particular chart, and then make the other groups "invisible" by turning off their borders and colors. The only approach that we could make work is to make a chart for every grouping in your original data. There is no way to group individual slices of the pie prior to exploding, nor does Excel provide a way to push selected slices together. Gloria was looking for a way to have different slices grouped together in the view.
When you pick an exploded pie chart as your chart type, all the slices of the pie are "pushed back," away from the center of the pie. Gloria asked if there was a way, in a 3-D pie chart, to "explode" groups of slices, instead of individual slices.
0 kommentar(er)
