how to make a pie chart in excel mac 2011

Click Close after finishing.ĥ. Select Fill to select options for filling legend box. It has automatically been set to left so it is present on the left.Ĥ. Right-click > Format Legend. Use color gradient to select color.ģ. Right-click > Format Legend. It is automatically selected.Ģ. Select desired style of filling slices. Changing Colorġ. To change color of slices, select Fill. Click Close, when done.ģ. To separate slices in pie-chart, set the Together distance. Editing Slicesġ. To edit slices in pie-chart, right-click anywhere on chart > Format Data Series.Ģ. To shift angle of a slice, set rotation angle by entering value or moving blue cursor. Right-click anywhere on pie-chart > Format Data Labels.Ģ. Label exists as simple numeric values (automatic).ģ. Select desired label. Editing Your Pie-Chart Labelingġ. The labels/values exist as automatically selected.

If plain white feels like a dull background for your pie-chart, you can also create it against a background image in Excel.ģ. Select the first cell and drag cursor till the last cell to select whole data.ĥ. A pie chart will automatically appear.Ħ. To enter the title of chart, click on highlighted area.ħ. Enter your chart’s title. Step-by-Step: How to Create a Pie Chart in Excel Getting Started: Naming Your Pie Chart

The experience is both creative and professional. From advanced chart labeling to simple worksheet tab options, Excel lets users create wholly customizable pie charts from myriad design options. A pie chart comprises of slices, each of which represents a given value in the form of numbers, percentages, series’ names and other forms. Close values are compared best by a bar graph. It is also used to compare one value set from another, but only if the values are too large or too small. It shows how much of a certain category contributes to the overall population. Pie chart is perhaps the most common method to represent data quantitatively.

How to make a pie chart in excel mac 2011