In case you need to study or you have to analyze dispersion data, such as your company’s market share, you can use the pie chart tool.
With this function, You will be able to clearly present a graph with 2 variables that are related to each other. To do this, you will have to follow a guide that we will show you in this post.
But this will not be the only thing you can access in this article, We will also show you all the tools you can use to make a pie chart without making any mistakes. and in a simple and fast way.
What are pie charts used for and in what kind of documents is it good to use them?
Pie charts are graphical tools that are used to expose information related to the participation that different elements have in a frequency distributionwhich is equal to 1 (or 100%).
That is, these types of illustrations can demonstrate how each concept participates in the total population or sample. In other words, what is the percentage they contribute to the total set.
What tools do we have in Excel to create pie charts?
To create pie charts you need the tool “Recommended graphics”which you can find in the menu “Insert”Within the group “Graphics”. You can also use the function “Insert pie or donut chart”which belongs to the same group.
You can make these illustrations based on a table in which you can modify the data so that the areas of the circular graph are changed.
You can also use “SmartArt” to incorporate a pie chart, but you won’t have the dynamics of changes like with the other tools. The same happens if you use “Insert images” from the computer or the Internet.
Steps to make pie charts to reflect statistics graphically in Excel
In case you need to present statistical information based on a pie or circular graph, you will need to know the steps that we will show you below so that you can present an illustration with a professional style.
The guide you should do is:
- Once you have the distribution table with the data, you will have to select the two scatter columns to get the graph.
- Then click on the tab “Insert” and look for the group of tools “Graphics”. select function “Recommended graphics”.
- Go to the tab “All Graphics”.
- Click on “Circular”.
- Choose the one that suits you.
What you can do now is modify chart title. For her, right click on that area to select it, then click on “Edit text” and write what you need. you can also change location the title by moving it with the mouse.
If you prefer, you can modify chart areaselecting the cake and then dragging it in or out.
Another setting is that you will be able to remove the outline of the chart area from the legend or title. To do this, you will have to right click outside the graph and select “Outline”. You can also avoid the fill by leaving it transparent or changing its color. For the latter, you will have to click on the option “Filling”.
Facebook Comments
Disqus