【Make Pie Chart in Excel】Step by Step Guide ▷ 2022

When working with this type of calculation programs It is very important to be able to know each of your tools and functionswhich will allow power make the most of it. In the case of microsoft program users have the ability to add a variety of items to your spreadsheets, such as .

in these work sheets users can insert a variety of chart typeswhere you can find what they are pie charts. These elements have become one of the most popular for showing what part of a total quantity each individual quantity representsideal for display annual sales statistics.

And it is that they are characterized by the entirety of its shape represents 100% of the data to be included and what are they going to separate by portions of different colors where each represents a part of the whole. Accordingly, here we are going to teach you a little more about this tool and how you can start creating them, for this, follow in detail everything that we will teach you next in the post.

What tools can we use to make pie charts in Excel?

Being able to insert these elements into your spreadsheet is very simple, this can be done either using the o Shapes toolwith either of them the user will be in the ability to add these statistical items to your worksheet.

It should be noted that this type of elements graphic is intended teach the portions of each of the parts with respect to the total, This means that the sum of all these parts will give The 100%. This will allow you to know the percentage of each of the parts of the circle graph.

These elements can be created from the tab “Insert” and then in the option “Graphic”, This procedure is very simple to carry out, so you only have to take into account what data you want to take for said statistical calculation, either to know annual and quarterly sales among others.

SmartArt or Shapes What is the best tool to make pie charts in Excel?

One of the main advantages of using MS Excel is that you will have the possibility of having a great variety of elements that will help you get desired results easily. In the case of adding circular graphs to your worksheet, you can do it through different tools, the most common for them are through the “Shapes” or “SmartArt”. However, it should be mentioned that these elements can also be added directly from the section of “Graphic” and in the item of “Circular”.

Since this process will lead you to insert said element directly. But if you are one of the users who wants it to be a little more personalized and your way then you can create it via the two tools already mentioned. if you want to know Which of the two is better?either because the procedure is simpler or because it offers better results, it could be said that SmartArt, since this tool offers you different forms of graphics.

In it you can select the one you like the most and then make the modifications you want. While in the case of “Shapes” here you can simply create the circle and then add everything else you think is necessary, so that the procedure in this case is a bit more tedious and long. Therefore, if measured by performance the tool “SmartArt” result better alternativesince with it you can save time so your work will be more profitable.

Learn step by step how to make your graphs round in Microsoft Excel

Bearing in mind the different ways in which create these circular elements in excelhere we are going to teach you how to create them through each of the methods already mentioned above. This will allow you to decide for yourself which of all of them is the simplest and the one that offers the best performance.

To do this, follow each of the methods that we will explain below:

with shapes

The first method that we present to you is about using the tool “Shapes” as mentioned above in the post, this method will force you to create your own pie chart right from the startso the procedure is more tedious and extensive than using other tools for it.

In order to carry out this process, you will need to perform the following steps that we will teach you below:

Once you are in your spreadsheet you should go to the tab “Insert”.
There you will find different sections, in this case click “Illustrations” in the option of “Shapes”.
As you can see, a list of all the forms that you have available there appears. In this case what you want create is a pie chartso it should choose the shape of a circle.

Once selected you must click on spreadsheet for the figure to appear, with the help mouse you give it the size and location you want.

One time selected figurein the ribbon you will find different sections where you can modify the color, the borders, add new lines, points, among many other elements.
In the part top left of your screen You will see a rectangle with several options, such as the option of text, lines, among others. Here you can select the line option to give the different partitions you want to the graph.
Once added the lines you will have the following:

Now you can add the percentage of each of the fractions you have created, As can be seen in this case, six portions are shown, which will be represented as follows:

As you can see each of the parts of the graph have a percentage with respect to 100%in this case each of these parts can mean different aspects depending on the data you are using for it.

With SmartArt

The other method that will allow you to perform these graphic elements in your excel sheet it is the tool SmartArt, this method is much simpler than the previous one since here you will not have to start from scratch as if it happened in the previous case.

For this, it is necessary that you follow each of the steps that we are going to teach you below:

Once you are inside the sheet of Excel you must access the tab “Insert”, there select the option “SmartArt” located in the section of “Illustrations”.
There a new window will open with all graphics models available in said tool, as desired create a pie chart, then you must go to the section “Cycle”.
There you will find different models, in this case select the one that is circular, once selected click on “To accept” to have it added to your worksheet.

Now the item will appear on the screen as follows:

As you can see at the top you will find different options with which you can modify its appearancethis will allow you to fully customize it your way.
The image that has been added only has three partsin case you want add a new part to her you must select the option “Add Shape” located in the part top left of your screen. Once selected the image will no longer be three parts but fourif you want add a new part you must repeat this step.

The next thing will be to add the text and the percentage to each of the parts of the element. Keep in mind that these added values are going to depend on the data you are working with, but this should be as follows:

This way you can start create your own graphics in your Excel spreadsheets whenever you want, keep in mind that each of the parts can be differentiated with a different color if you want.

With graphics option

Finally, we present you the most common and easiest method to add these types of items in your spreadsheets. In this case it is about using the Excel charting tool.

To do this you must follow these steps:

How long are you in your spreadsheet you should add the values or data that you want to use in the element in one of the columns of the sheet.
Once added you must select them and click on the tab “Insert”.
Then select the option “Circular” within the section of “Graphics”.

There they will appear to you various chart templates availableIn this case, select the one that you like the most.

As you can see on the screen it appears the image according to the data you have previously selected where each of The parties have their percentage. At the top of your screen you will find different elements that they will allow you to customize the image a little more.

This way you can also add these graphical representations to your worksheets in a much more direct and easy way, which will allow you to reduce working time and therefore achieve better performance.