How to Make a Pie Chart in Excel

How to Make a Pie Chart in Excel

A pie chart is a circle graph in Excel that is parted into different slices. Each slice of pie chart defines a proportion of the whole. This graphical object is used to show the percentage of the data in the chart.

Uses of a Pie Chart

Pie chart is an excellent tool in Excel that helps to create an attractive visualization of complex numbers. You can use it to create proposals, your annual sales forecast, and much more. However, we suggest not to use Pie chart for data having more than 6 categories. Since, the large numbers of categories may look bad in a single chart. It may make chart difficult to interpret and understand. click here for more details.

Microsoft Excel gives you a range of options to create pie charts including 2D and 3D pie charts that come with a variety of designs and types.

Pie Chart is usually created to present data that can be classified into nominal or ordinal categories and shows percentage. At present, Pie chart is one the most loved and accepted formats to present data in a visual form.

Steps to Make a Pie Chart in Excel

Microsoft Excel is an excellent tool to create a pie chart in just a few clicks. Here are steps, following them you can learn making pie charts in no time.

Step 1: Type Data into an MS Excel Sheet-

First, type your list of data in Excel in two columns, which is quite easy. Type your description of the numbers in column 1st and your numbers in column 2nd. As in the following example, the column A contains the categories of animals and column B has numbers associated with these animal categories. Make sure you are not leaving any blank rows or columns while typing the data. for related info, visit :

How to Make a Pie Chart in Excel

Step 2

Select the entire entered data by clicking on the top of your data and pull the mouse pointer to the bottom right.

Step 3

Now go to “Insert Menu” of your worksheet and click on “Pie” and then select the type of pie chart you are looking for. Now click on chart icon you have chosen; Excel will immediately insert pie chart into your excel worksheet.


In case you have made a mistake while typing your data in Excel, you don’t need to create the whole chart again. Microsoft Excel gives you the advantage; when you make a correction in the original data, your pie chart automatically gets corrected.…

What is Excel

What is Excel

Sometime before 1993, Lotus 1-2-3 used to be the industry standard for the spreadsheet application. But later that year, tables turned when Microsoft Corporation introduced the modern version of Microsoft Excel. This propriety commercial application which is part of the extended Microsoft Office Suite family became an instant hit and quickly replaced Lotus-1-2-3 as the preferred Spreadsheet software at business places. To date, it has become essential to possess Microsoft Excel usage skills to work in any office or complete some personal spreadsheet projects. for related info, click here.

Microsoft Excel possesses basic spreadsheet features of organizing its workspace in a grid of cells that are arranged in numbered columns and rows which are used to organize data and manipulate arithmetic operations. It comes with a variety of functions and formulas that can be used to quickly perform some statistical, financial and engineering calculations. It can also prepare a pictorial representation of your data using histograms, line graphs, charts and some limited 3D graphical displays. for more about excel, click on  :

What is Excel

To use Microsoft excel, you need to ensure that any latest version of Microsoft Office suite is installed on your computer. For Windows 7 Ultimate and other older versions, click on the start button then programs. On programs menu, click on Microsoft Office and select Microsoft Excel from the list. For Windows 8.1 and Windows 10, click on windows logo at the bottom left corner followed by a click on the down arrow at the bottom. Proceed to the Microsoft Office group from where you can launch Microsoft Excel.…