how to make a pie chart in excel with two colloms

That’s especially necessary when you have long labels. For the rest of the value, use shades of one color rainbow colors will distract readers from comparing the pie shares.Ĭonsider labelling smaller pie slices outside of the chart, since pie charts are hard to label.

Use colors to make your most important value stand out. Notice how Ive included a table visual on the left so we can be sure which supplier were looking at.ĭon’t Miss: Show Me A Recipe For Chicken Pot Pie How To Make Your Pie Charts Better This will drill you down to show the breakdown of TYPE for each supplier and show you the percentage youre after. To do this, click on the down pointing arrow to turn drill down on and then click on a suppliers segment in the pie chart. If you put the TYPE column also in the Legend bucket under SUPPLIER, you can then drill down to the percentages for each SUPPLIER. This is where the drill down can help us. But what were itching to do here is to show what percentage each wine type is of each suppliers sales, not of the total sales. Of course, this is how the pie chart has to behave because a pie chart must always show the ratio of the parts to the whole. Because of this, Ive had to display the legend so we can tell which colour is which supplier. Notice how the detail labels show percentages for the Details rather than SUPPLIER. If you want the value with the percentage click on both and close it.

This will open up the Format Data Label option on the right side of your worksheet. To do this select the More Options from Data labels under the Chart Elements or by selecting the chart right click on to the mouse button and select Format Data Labels. # Formatting Data Labels Of The Pie Chart To select a single slice, click on it, and then click it again so that only this slice is selected. To draw your users’ attention to a certain slice of a pie, you can move it out from the rest of the pie chart.Īnd again, the quickest way to pull out an individual slice is to select it and drag away from the center using the mouse. Pulling out a single slice of a pie chart Or, type the desired number directly in the percentage box:

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.

How to make a pie chart in excel with two colloms