When working with this type of spreadsheet program, it's very important to be familiar with each of its tools and functions , which will allow you to get the most out of it . In the case of Microsoft's program , users have the ability to add a wide variety of elements to their spreadsheets, such as charts.
In these worksheets, users can insert a wide variety of chart types , including pie charts . These have become one of the most popular ways to show what percentage of a total each individual quantity represents , ideal for displaying annual sales statistics.
These charts are characterized by the fact that their entire shape represents 100% of the data to be included , which is then separated into portions of different colors, each representing a part of the whole . Accordingly, we'll teach you a little more about this tool and how you can start creating them . To do so, carefully follow everything we'll show you in the following post.
What tools can we use to create pie charts in Excel?
Inserting these elements into your Excel spreadsheet is very simple; this can be done using either the SmartArt or Shapes tool . With either of these, the user will be able to add these statistical elements to their worksheet.
It's important to note that this type of graphic is designed to show the proportions of each part relative to the whole; that is, the sum of all those parts will equal 100%. This allows you to determine the percentage of each part in the pie chart.
These elements can be created from the "Insert" tab and then in the "Chart" option . This procedure is very simple to perform, so you only need to keep in mind what data you want to use for this statistical calculation , whether it is to know the annual sales, quarterly sales, among others.
SmartArt or Shapes: Which is the best tool for creating pie charts in Excel?
One of the main advantages of using Microsoft Excel is the wide variety of tools available to help you easily achieve your desired results . Adding pie charts to your worksheet can be done through various tools, the most common being "Shapes" or "SmartArt." However, it's worth noting that these elements can also be added directly from the "Chart" tab , specifically the "Pie" option.
This process will allow you to insert the element directly . However, if you prefer a more personalized experience , you can create it using the two tools mentioned earlier . If you're wondering which is better , whether due to a simpler procedure or superior results, SmartArt offers a wider variety of graphic styles.
In SmartArt, you can select the one you like best and then make any modifications you want. With Shapes, on the other hand, you simply create the circle and then add everything else you need, making the process a bit more tedious and time-consuming . Therefore, if performance is the measure, SmartArt is a better alternative , as it saves time and makes your work more efficient.
Learn step by step how to create your own round charts in Microsoft Excel
Given the different ways to create these circular elements in Excel , we'll show you how to create them using each of the methods mentioned above. This will allow you to decide for yourself which one is the simplest and offers the best performance.
To do this, follow each of the methods that we will explain below:
With Shapes
The first method we present involves using the "Shapes" tool , as mentioned earlier in the post. This method will require you to create the circular chart yourself from scratch , making the process more tedious and lengthy than using other tools.
To carry out this process, you will need to perform the following steps, which we will teach you below:
- Once you are in your spreadsheet You need to go to the tab of "Insert".
- There you will find different sections, in this case click “Illustrations” in the option of “Forms”.
- As you can see, a list appears of all the available options. In this case, what we want is... Create a pie chartTherefore, it will be necessary choose the shape of a circle.
- Once selected, you must click on the spreadsheet so that the figure appears, with the help You give the mouse the size and location you want.
- Once the selected figure, the ribbon You will find different sections where you can modify the color, borders, add new lines, points, among many other elements.
- In the part top left of your screen You'll see a rectangle with several options, such as the option to text, lines, among others. Here you can select the line option to give the graph the different partitions you want.
- Once added the lines It will look like this:
- 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 one of The parts of the graph have a percentage relative to 100%.In this case, each of these parts can signify different aspects depending on the data you are using for that.
With SmartArt
The other method that will allow you to create these graphic elements in your Excel sheet is the SmartArt tool. This method is much simpler than the previous one since you won't have to start from scratch as you did in the previous case.
To do this, you need to follow each of the steps that we are going to teach you below:
- Once you are inside the sheet of Excel You will need to access the tab of "Insert", there, select the option of “SmartArt” located in the section of “Illustrations”.
- A new window will open there with all the graph models available in that tool, as desired create a pie chart, Then you should go to the section of "Cycle".
- There you will find different models; in this case, select the circular one. Once selected, click on "To accept" so that it can be added to your worksheet.
- Now The item will appear on your screen As follows:
- As you can see at the top you will find different options with which you will be able to modify its appearanceThis will allow you to completely customize it to your liking.
- The image that has been added only It has three parts, in case you want add a new part to her You must select the option of “Add shape” located in the part top left of your screenOnce the image is selected, it will no longer be three parts but of four, if you want To add a new part, you must repeat this step.
- The following will be Add the text and the percentage to each of the parts of the element. Keep in mind that these added values will It depends on the data you're working with, But it should look like this:
- This way you can begin to create your own graphics en your Excel spreadsheets Whenever you wish, keep in mind that you can differentiate each of the parts with a different color if you wish.
With the graphics option
Finally, we present the most common and simplest method for adding these types of elements to your spreadsheets . In this case, it involves using Excel's charting tool.
To do this you must follow these steps:
- When you find yourself in your spreadsheet you must Add the values or data you want to use in the element to one of the columns in the sheet..
- Once added, you must select them and click on the tab. "Insert".
- Then select the option "Circular" within the section of "Graphics".
- They will appear there several available graphics modelsIn this case, select the one you like best.
- As you can see on the screen, it appears the image according to the data you have previously selected where each of each party has its 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 reduce working time and therefore achieve better performance.
