Video lesson “Pie graphs. Excel. Pie chart with two data sets
Good day!
Quite often, when working at a computer, you need to build some kind of graph or diagram (for example, when preparing a presentation, report, abstract, etc.),
The process itself is not complicated, but it often raises questions (even for those who have been sitting at a PC for several days). In the example below, I would like to show how to build various charts in the popular Excel program (version 2016). The choice fell on it, since it is available on almost every home PC (after all, the Microsoft Office package is still considered basic for many).
A quick way to plot a graph
What's good about the new Excel is not only that it has higher system requirements and a more modern design, but also simpler and faster graphics capabilities.
I’ll show you now how you can build a graph in Excel 2016 in just a couple of steps.
1) First, open a document in Excel on the basis of which we are going to build a graph. Typically, it consists of a plate with several data. In my case, a table with a variety of Windows operating systems.
You need to select the entire table (an example is shown in the screenshot below).
The bottom line is that Excel itself will analyze your table and offer the most optimal and visual options for its presentation. Those. you don’t have to configure anything, adjust anything, fill in data, etc. In general, I recommend it for use.
3) In the form that appears, select the type of chart that you like. I chose a classic line graph (see example below).
Actually, the diagram (graph) is ready! Now you can insert it in the form of a picture (or diagram) into a presentation or report.
By the way, it would be nice to give the diagram a name (but it’s quite simple and easy, so I won’t stop there)...
To create a pie or scatter chart (which are very visual and loved by many users), you need a certain type of data.
The point is that in order for a pie chart to clearly show the relationship, you need to use only one row from the table, and not all of them. It is clearly shown what we are talking about in the screenshot below.
Selecting a chart based on data type
So, let’s build a pie chart (screen below, see arrow numbers):
- First, select our table;
- then go to the section "Insert" ;
- click on the icon ;
- further in the list we select "Pie Chart" , click OK.
Constructing a scatter or any other chart
In this case, all actions will be similar: also select the table, in the “Insert” section, select and click on “Recommended charts”, and then select "All diagrams" (see arrow 4 in the screenshot below).
Actually, here you will see all the available charts: histogram, graph, pie, line, scatter, stock, surface, radar, tree, sunburst, box, etc. (see screenshot below). Moreover, by selecting one of the chart types, you can also choose its type, for example, select the 3-D display option. In general, choose according to your requirements...
Perhaps the only point: those charts that Excel did not recommend to you will not always accurately and clearly display the patterns of your table. Perhaps it’s worth sticking with the ones he recommends?
I have everything, good luck!
Pie charts are one of the types of area charts that are easy to understand. They show parts of a total and are a useful tool when analyzing surveys, statistics, complex data, income or expenses. Such diagrams are very informative - the audience can see what is happening. Use pie charts to make great presentations for school and work projects.
Steps
Building a Pie Chart
- build a pie chart 1 Calculate the pie chart (its proportions).
- build a pie chart 2 Collect numerical data and write them in a column in descending order.
- build a pie chart 3 Find the total sum of all the values (to do this, simply add them up).
- create a pie chart 4 For each value, calculate its percentage of the total; to do this, divide each value by the total.
- build a pie chart 5 Calculate the angle between the two sides of each sector of the pie chart. To do this, multiply each percentage found (as a decimal) by 360.
- The logic of the process is that there are 360 degrees in a circle. If you know that 14400 is 30% (0.3) of the total, then you calculate 30% of 360: 0.3*360=108.
- Check your calculations. Add the calculated angles (in degrees) for each value. The sum should be equal to 360. If this is not the case, then an error was made and everything must be recalculated.
- build a pie chart 6 Use a compass to draw a circle. To draw a pie chart, you need to start with a perfect circle. This can be done using a compass (and a protractor for measuring angles). If you don't have a compass, try using any round object, such as a lid or CD.
- build a pie chart 7 Draw a radius. Start at the center of the circle (the point where you placed the compass needle) and draw a straight line to any point on the circle.
- A straight line can be vertical (connecting 12 and 6 o'clock on the dial) or horizontal (connecting 9 and 3 o'clock on the dial). Create segments by moving sequentially clockwise or counterclockwise.
- build a pie chart 8 Place the protractor on the circle. Place it on the circle so that the center of the protractor ruler coincides with the center of the circle, and the 0 degree mark coincides with the radius drawn above.
- build a pie chart 9 Draw the segments. Draw the segments using a protractor to plot the angles calculated in the previous steps. Each time you add a segment (draw a new radius), rotate the protractor accordingly.
- When making corner marks, make sure they are clearly visible.
- build a pie chart 10 Color each segment. You can use different colors, line types, or just words depending on what best suits your purposes. Add a title and percentage for each segment.
- Color each segment of the pie chart to make it easier to see the results.
- If you are drawing a diagram with a pencil, trace the outline of the diagram with a pen or marker before coloring it.
- The names and numbers in each segment should be written horizontally and centered (at the same distance from the edge for each segment). This makes them easier to read.
- Double check that all angles are accurate.
- Remember that all good graphs have a title and captions.
- Check your calculations carefully because if they are incorrect, you will end up with an incorrect graph.
- More complex forms of the pie chart involve isolating a segment by removing it, or constructing a cut chart where each segment is depicted separately from the other. This can be done manually or using a computer program.
- If you don't have a very good compass, it's easier to draw a circle by holding the compass and rotating the paper.
- Objects such as coins or flags can be turned into pie charts (for visual appeal).
- Make sure that the sum of the percentages found is equal to 100%.
- Once you become proficient at making these charts, you can shift the perspective of the pie chart to become a 3D or layered chart. These are more advanced forms of pie chart and require more detailed work and knowledge.
Warnings
- Always check your work to make sure the calculations are correct.
What you will need
- Compass (or round object)
- Protractor
- Pencil and paper
- Eraser
- Markers or colored pencils
Pie charts– represent a circle divided into sectors (cake), and are used to show the relative value that makes up a single whole. The largest sector of the circle should be the first one clockwise from the top. Each sector of the circle must be labeled (name, value and percentage are required). If it is necessary to focus on a certain sector, it is separated from the rest.
The pie chart type is useful when you want to display the share of each value in the total.
Let's build a three-dimensional pie chart that displays production load throughout the year.
Rice. Data for charting.
With the help of a pie chart, only one series of data can be shown, each element of which corresponds to a specific sector of the circle. The area of the sector as a percentage of the area of the entire circle is equal to the share of the row element in the sum of all elements. Thus, the sum of all shares by season is 100%. The pie chart created from this data is shown in the figure:
Rice. Pie chart.
Excel provides 6 types of pie charts:
Rice. Types of pie chart.
circular – displays the contribution of each value to the total;
volumetric circular;
secondary pie – part of the values of the main chart is placed on the second chart;
cut circular – sectors of values are separated from each other;
volumetric cut circular;
secondary histogram – part of the values of the main diagram is displayed in a histogram.
If you want to separate slices in a pie chart, you don't have to change the chart type. Simply select the circle and drag any sector away from the center. To return the chart to its original appearance, drag the sector in the opposite direction.
Rice.
It should be remembered that if you want to separate only one sector, you should make two single clicks on it. The first will select a row of data, the second – the specified sector.
Rice. Change the appearance of a pie chart.
In a pie chart, the sectors can be rotated 360 in a circle. To do this, select the tab on the ribbon Layout and point Selection Format.
A secondary pie chart, like a secondary histogram, allows some portion of the data to be displayed separately, in more detail, in a secondary chart or histogram. Moreover, the secondary diagram is taken into account in the primary diagram as a separate share. As an example, consider a chart showing sales volume for the week, where the weekend portion is plotted as a secondary pie chart. When choosing a chart type, indicate Secondary circular.
Rice. Secondary diagram.
Data that is arranged in columns and rows can be depicted as a scatter plot. A scatter plot shows relationships between numerical values in multiple data series, or displays two groups of numbers as a single series of x and y coordinates.
Scatter plot has two value axes, with some numerical values displayed along the horizontal axis (X-axis) and others along the vertical axis (Y-axis). A scatter plot combines these values into a single point and displays them at irregular intervals or clusters. Scatter plots are typically used to illustrate and compare numerical values, such as scientific, statistical, or technical data.
§ 1 What is a diagram?
In this lesson, you will not only learn what a pie chart is, but also learn the basic skills of creating, reading, and working with pie charts. Let's start with what is a diagram, what and where is it used?
Often in our lives, the results of human activity, for example, comparing the cost of products, the composition of various mixtures, or some other numerical data, are more convenient to present visually, in the form of a picture. It is easier to compare numerical values if they are represented as graphical objects of different sizes. Drawings are better perceived by humans. Using them, you can clearly compare the results and draw certain conclusions. Such drawings are called graphs and diagrams.
Today we will get acquainted with diagrams. A diagram (from Greek “image, drawing, drawing”) is a graphical representation of data that allows you to quickly assess the relationship of several quantities.
§ 2 Types of diagrams
There are many types of diagrams known. They can be planar and volumetric. Among the diagrams there are:
etc. We will study pie charts.
§ 3 Pie chart
Pie charts are a fairly common type of chart; an integer value is depicted in such charts as a circle. And part of the whole is in the form of a sector of a circle, i.e. its part, the area of which corresponds to the contribution of this part to the whole. This type of diagram is convenient to use when you need to show the share of each value in the total volume.
§ 4 How to build a pie chart?
Let's look at a specific example. An alloy of iron and tin contains 70% pure iron, the rest is tin. To visually depict this situation, let's draw a circle and paint 70% of its area red and the remaining 30% blue.
Because in a circle 180 +180=360º, then you need to find 30% of 360º. For this, 360:100 ∙ 30= 108º. This means you need to draw two radii at an angle of 108º and paint the part of the circle between them blue, and the rest of the circle red. So we have a pie chart.
More often than not, to construct a pie chart, you have to break the circle into more parts. For example, let's create a nutrition pie chart for students. For schoolchildren, the most important five meals a day is: first breakfast - 20%, second breakfast - 15%, lunch - 40%, afternoon snack - 10%, dinner - 15% of the daily diet.
First, let's find how many degrees there are in each area. Let's perform the following calculations:
1) 360: 100 ∙ 20 = 72º - this occurs at morning breakfast
2) 360: 100 ∙ 15 = 54º - second breakfast
3) 360: 100 ∙ 40 = 144º - occurs at lunch
4) 360: 100 ∙ 10 = 36º - afternoon snack
5) 360: 100 ∙ 15 = 54º - dinner
Now, in the circle we draw radii OA, OB, OS, OD and OE so that angle AOB is 72º, angle BOC is 54º, angle COD is 144º, angle DOE is 36º and angle EOA is 54º. Next, all that remains is to choose colors and paint over each area. We received a pie chart, from which it is very clearly seen that the most nutrition comes from lunch, and the least from the afternoon snack.
By the way, it should be noted that a pie chart remains visual only if the number of parts of the whole chart is small. If there are too many parts of the diagram, its use is ineffective due to the insignificant differences in the data being compared.
Thus, in this lesson you learned what a pie chart is and learned how to build them yourself.
List of used literature:
- Mathematics 5th grade. Vilenkin N.Ya., Zhokhov V.I. and others. 31st ed., erased. - M: 2013.
- Didactic materials for mathematics grade 5. Author - Popov M.A. - 2013
- We calculate without errors. Work with self-test in mathematics grades 5-6. Author - Minaeva S.S. - 2014
- Didactic materials for mathematics grade 5. Authors: Dorofeev G.V., Kuznetsova L.V. - 2010
- Tests and independent work in mathematics grade 5. Authors - Popov M.A. - 2012
- Mathematics. 5th grade: educational. for general education students. institutions / I. I. Zubareva, A. G. Mordkovich. - 9th ed., erased. - M.: Mnemosyne, 2009. - 270 pp.: ill.
Let's continue the topic creating charts in Excel 2007. Pie charts are suitable for information in which you want to display the share of one object in overall statistics. Pie charts can be flat, three-dimensional, cut. In this lesson we will look at how to create a 3D pie chart in Excel. Fill the diagram area with a texture and change the characteristics of the boundaries for the diagram area and legend, and also change the color of the diagram title.
So, below is a table of information about the sales of individual employees of any department, for which we will build a diagram:
Select the data range in our case it is —
B4:C9. Go to the panel Insert, select a section Diagrams, press the button Circular and select the item Circular volumetric. In parentheses we give the command in abbreviated form.
(Insert - Diagrams - Pie - Pie 3D)
We get a diagram like the figure below.
Let's make the diagram more attractive. The figure does not show each employee's sales figures in numbers. In order to add this data, do the following: select the panel Constructor, we find Chart Layouts, select a layout Layout 6.
(Designer - Chart Layouts - Layout 6)
The chart displays each employee's sales as a percentage of the total sales of the entire department. If you are satisfied with the presentation of the data as a percentage, we do not change anything. If you need to display values in rubles, go to the panel Layout, in section Signatures press the button Data Signatures and select the item Additional data signature options...
(Layout - Captions - Data Labels - Additional Data Labels Options...)
In a pop-up window in section Signature Options enable the option Values, remove the remaining options.
In the same window go to the section Number and set up the number format: in the area Number formats select the format Monetary, press the button Close.
Changing the chart style: panel Constructor, section Chart styles, select Style 26.
(Constructor - Styles
diagrams - Style 26)
The diagram will look like:
Changing the chart background: on panel Format, in section Shape styles, press the button Filling a shape, in the pop-up menu select the item Texture, select a texture Canvas.
(Format — Shape styles — Filling a shape — Texture – Canvas)
Set the color and thickness of the chart border:
(Format — Shape styles — Figure outline – Theme colors – Blue, Accent 1, darker shade 25%)
(Format — Shape styles — Figure outline – Thickness –1.5 pt)
Next, let's change the legend settings: on panel Layout in section Signatures press the button Legend, select the item Additional legend options...
(Layout
— Signatures — Legend — Additional legend options...)
1) In a pop-up window Legend Format select a section Fill, in the right part of the window select the option Solid Fill, Color White, Background 1.
2) Further in the section Border color select the option Solid line and choose Color Blue, Accent 1, darker shade 25%.
3) Change the border thickness in the same window ( Legend format) select a section Border styles, in the field Width set the value 1.5 pt, press the button Close .
Make the chart title color a little darker than the border color, on the panel Format in section StylesWordArt click on the triangle next to the button Fill text, select a color from the pop-up menu Blue, Accent 1, darker shade 50%.
(Format
— Styles
WordArt — Fill text — Blue, Accent 1, darker shade 50%.)
To edit the title, double-click on it with the left mouse button. The design of the header is described in more detail in the article "".
Let's give some convexity to the figure: on panel Format in section Current fragment press the button Selection Format.
(Format — Current fragment — Selection Format)
In a pop-up window Chart Area Format select a section Rotate a volumetric figure, change field values, Y=40º and Perspective=30º, press the button Close.
If the numbers on the diagram go beyond the boundaries of the figure, increase the area of the diagram; to do this, simply drag the border of the diagram. As a result, we get the following diagram.
So, we have looked at how to create a pie chart in Excel 2007.
Important Note: All the above commands can be executed through the pop-up menu by right-clicking on the selected diagram object. If you liked the article or have questions on this topic, write in the comments or through the feedback form.