Pie chart step by step

The clarity of the provision of information data and its availability to the human brain primarily depends on the form of its presentation. Therefore, many try to visualize information as easily as possible and to present its necessary aspects to the audience as conveniently as possible. In this case, pie charts are quite effective. They are used almost everywhere where you need to show the aspect ratio, a percentage of the total, and the like.

Pie chart

A pie chart is a convenient tool for displaying data, since it can be used to divide different columns of data into different sectors of the same circle, thereby emphasizing which segment this or that information occupies in the whole information space. It is worth noting that the appropriateness of using this type of diagrams applies only if the data you want to divide into no more than 6 structural parts.

Pie charts
For example, if you have 5 types of items in the warehouse (books, magazines, pens, covers and pencils) and you need to graphically show the percentage of filling the warehouse with one or another type of product, then a pie chart will be the best choice, at the same time, if If you have more than 50 types of goods, then the expediency of using this type of diagram is significantly reduced, since graphically such a representation will not be a very obvious example.

The easiest tool to create a pie chart is Excel (a table processor provided by Microsoft). Moreover, this application has in its functionality not only this type of diagram, but also many others.

Let's look at how to insert an object such as a pie chart in Excel. First of all, it is necessary to enter on the application sheet data on which the object will be built. Next, you need to perform the following sequence of operations.

Excel Charts

1. Go to the "Insert" tab.

2. On the toolbar, select and click "Charts".

3. In the "Insert Chart" window that appears, click on the "Pie" item, select the chart subtype (Pie, Secondary Pie, Volume Pie, Split Pie or Secondary Bar Chart) and click the "OK" button.

4. If you have not previously selected the data on which the pie chart will be built, then a blank canvas called “Chart Area” will appear on the current sheet in front of you. It is worth noting that at this time Excel will switch to the “Work with Charts” tab, which has submenus: Format, Layout and Constructor.

5. To build a chart, right-click on “Chart Areas” and select “Select Data” from the context menu. In the "Select Data Source" window, fix the range over which you are going to build a pie chart, and click "OK."

As a result, a chart appears on the sheet that matches your data. If you don’t like the colors of the sectors of the chart or its layout, you want to individualize the labels, then you can easily select the necessary parameters in the above-mentioned submenu items. You can also move the constructed chart to a separate sheet. To do this, just click on the "Move Chart" button in the "Designer" submenu.


All Articles