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 2007