Create A Pie Chart In Excel 2011 How To Create Pie

Here in this post and the next, Ill show you how to create Pie charts in Excel using your Worksheet data.

I have four columns and five rows on sheet1, which shows some figures (sales for example) for each product.

The columns are the products and each row has monthly sold units of each product.

Click the Pie option and choose a type, either 2D or 3D, depending on your requirement.

Repeat the process for all the rows and you have multiple Pie charts on sheet1.

I wish to see the number of sales for my products (pen, ruler etc.) for every month.

This is vertical selection.

Click the mouse on the first column, first row and drag the mouse down until the last row.

Next, hold the Ctrl key, click the 3rd column (ruler) and drag the mouse till the last row.

Double click a particular slice, hold and drag it out to separate it from the other slices.

When you insert a Pie chart on your worksheet, it will show different slices, a title and a legend, without the data labels.

It shows the slices, the title and the legend (apr, may etc.).

The slices are the figures or the units sold (10, 20, 30 etc.).

Without the data labels it is difficult to understand what each slice indicates.

Simply double click the slice for which you want to add labels and repeat steps 1 and 2.

It will show a small popup box.

Choose option Format Data Labels.

How To Create A Pie Chart In Excel 2011 For Mac