Pie Diagram - It is a sub-divided circle diagram . The comparison of the pie diagrams is to be made on the basis of the areas of the circles . The circle (representing the total) may be divided into various sections or segments which is the certain proportion or percentage of the total . It is also known as circular diagram.
Steps on Excel :
Steps: Select the data which you want to show in pie diagram. See below print shot for an example: We selected A1:B4
Note: Column D (Angle) and column E (Percentage), we calculated just to verify the graph section percentage..
Formula for Column D (Angle at the centre ) = (component value/total value)*360 degrees.
i.e. =B2/$B$5*360
The angle at the centre of the circle is 360 degrees . And the total data is obviously represented 100 percentage. Which implies that 1 percentage is equal to 3.6 degrees. So, if we divide the data in angle terms by 3.6 and multiply by 100, we get the data in percentage terms.
Formula for Column E (Percentage) = D2/360*100
Steps on Excel :
Steps: Select the data which you want to show in pie diagram. See below print shot for an example: We selected A1:B4
Now, click on insert tab and select 2-D pie graph.
Pie Graph is inserted. What we like to know is the percentage of divided section. Add data labels as in below:
From format data label dialog box , select percentage and other option as you like :-
Note: Column D (Angle) and column E (Percentage), we calculated just to verify the graph section percentage..
Formula for Column D (Angle at the centre ) = (component value/total value)*360 degrees.
i.e. =B2/$B$5*360
The angle at the centre of the circle is 360 degrees . And the total data is obviously represented 100 percentage. Which implies that 1 percentage is equal to 3.6 degrees. So, if we divide the data in angle terms by 3.6 and multiply by 100, we get the data in percentage terms.
Formula for Column E (Percentage) = D2/360*100
No comments:
Post a Comment