Alternatively, click anywhere within your pie chart to activate the Chart Tools tabs on the ribbon, go to the Design tab Chart Styles group and click the Change Colors button: Choosing colors for each slice individually As you can see in the screenshot above, the choice of color themes for Excel charts is quite limited, and if you are aiming to make a stylish and attractive pie graph, you may want to choose each slice color individually. Changing the color them of the pie chart in Excel To choose another color theme for your Excel pie graph, click the Chart Styles button, go to the Color tab and select the color theme you want. Changing the pie chart colors If you are not quite happy with the default colors of your Excel pie graph, you can either. Make a pie chart from the PivoteTable and it whenever necessary. In the Sort dialog window, choose to sort the data in the Values field either is ascending or descending order. Or, type the desired number directly in the percentage box: Pulling out a single slice of a pie chart To draw your users' attention to a certain slice of a pie, you can move it out from the rest of the pie chart. On the Format Data Series pane, switch to the Series Options tab, and drag the Pie Explosion slider to increase or decrease gaps between the slices. Right-click any slice within your Excel pie graph, and select Format Data Series from the context menu. For more precise control of the pie chart separation, do the following.
Exploded pie charts in Excel can be displayed in 2-D and 3-D formats, and you can also explode doughnut graphs: Exploding the entire pie chart in Excel The quickest way to explode the entire pie chart in Excel is to click it so that all of the slices get selected, and then drag them away from the center of the chart using the mouse.
Or, you can add emphasis to individual slices by pulling them out from the rest of the pie graph. Move all the slices away from the center of the pie.
0 kommentar(er)
