how to create pie charts from data in excel 2011 for mac

Here, you can set precisely the percentage of the pie explosion.

A pie chart should use between two and six data points- too many slices may make it difficult to interpret.

It can only display data that belongs to one data series, and each of its values must be positive.

When you use the 3-D Pie Chart you will get access to additional tools, such as 3-D rotation and Perspective, which is not available in the standard 2-D chart.

The difference is that the selected slices are displayed on the Bar chart instead.

First, click the chart, then click the first of the three icons that are located on the right side of the chart; A new menu will appear.

Check the Data Labels position and click the arrow to the right.

You can remove it because it doesnt make sense to duplicate information.

To change this, right-click the data labels and select Format Data Labels; The LABEL OPTIONS menu will appear.

Many people think that the first slice should always start at 12 oclock, and other slices should appear in a clockwise direction.

However, a good method, especially when youre dealing with lots of tiny parts is to start displaying them, not at 12 oclock, but at 3 oclock, starting with the smallest slices.

Thanks to this method you have a lot of space on the data labels so they wont overlap.

It shows mass and diameter of all planets in the Solar System.

Its a good decision to turn the chart by 90 degrees clockwise so you can have more space for data labels.

You can change it by selecting different chart style in CHART TOOLS DESIGN Chart Styles.

Both charts display a slice of a pie chart inside another chart.

Therefore, in the following example, these planets will be shown in a separate chart in order to see exactly the relationship between their masses.

The second chart consists of 3 gas giants (Uranus, Saturn, Neptune) instead of the rocky planets (Mercury, Mars, Venus, Earth).

First, right-click one of the charts and select Format Data Series.

If you dont want to see a pie chart as the second chart you can use the Bar of Pie Chart instead.

You can set it between 0 and 90 degrees, where 90 degrees is the view from the top.

If you move the mouse cursor outward, all of those slices will start moving apart.

Right-click to open the contextual menu, then select Format Data Series.

How To Create Pie Charts From Data In Excel 2011 For Mac