Part -17 – Pie Chart In MS Excel
Download Excel Templates – Pie Chart In MS Excel
Transcript For The Video – Pie Chart In MS Excel
Pie Chart In MS Excel
So the other things which are very important should be the data tables, if you want to actually add a table to your chart, you can use data tables, the table on which the chart was made, if you want to have it inside your chart itself, you can actually use show data tables from the data table menu and as you can see the table which is here gets populated in the chart itself. So which becomes a part of the chart and you can directly show that on your presentation or your report.
Likewise, other things which are important is from the point of view of some kind of layout, you may not like a design that, let’s say employee count is on the left-hand side, you may want it on the right-hand side, likewise you may not want the horizontal axis to be visible at all. So all these things can be managed under the axis and let’s say you know under the primary axis if I want to show the axis in thousands or millions or billions or logscales, you know that can be done. Likewise, for the horizontal axis, I don’t want the horizontal axis to be shown from left to right. Let’s say I want to show it from right to left, I can do that.
So as you can see you know the axis shifts from right to left, so if you want to play with this and find that this is adding value, you can choose this set of options, for your set of the graph. Likewise, another thing which is again can be important for many, would be the grid lines. These grid lines provide an intuitive way to understand where the charts or the values are. So say for example if I add a vertical primary grid line which is not basically visible as of now the grid lines is basically these one, which I have selected these are the horizontal grid lines, the vertical grid lines here are missing so we can add these vertical grid lines, and you will find that these vertical grid lines are now visible. Likewise, these vertical grid lines which we have selected were the major gridlines. If you want you can have some minor gridlines as well, which can show a unit between the larger set of units. So these grid lines are also an important way to probably make your chart look more intuitive. On one side you may want to include this, on the other side you may want to really delete this. So how do you go about deleting these grid lines? So its very easy, you just need to select these grid lines, just go on any grid line and just click it and just right click and press delete. So as you can see, this grid line which was horizontal grid lines that were selected got deleted.
Likewise let me select this horizontal axis minor grid lines and right click and delete, so the moment I delete it my graph looks even cleaner in this case. So this is another thing which you can kind of play with. The other aspect which I kind of forgot to tell you initially was with, so this was the chart area, this is the default chart area which is visible, you can play with this chart area, you can increase it from the bottom then decrease the size, you can increase the size as per the requirement of your presentation or the report that you are preparing, so you can have that as well. Likewise, the other thing which is important is the plot area.
The outside one is the chart area which we were kind of manually adjusting, the inside one is the plot area, you can also adjust the plot areas by selecting different options or different sizes so you can resize the plot areas as per your convenience. So that’s again one of the important things that you want to kind of showcase. Another aspect of formatting the chart could be something like let’s say if you want to decrease the font size of axis here, you can just select these and go to home menu and you can decrease the sizes, let’s say I want to decrease the size of this font, I can select those set of axis and decrease or increase the sizes accordingly. and likewise, let’s say I want to highlight a particular bar and not all set of bars.
Let’s say I want to colour marketing with let’s say blue colour and the remaining I just want them to be kept in grey so how can I do that, I can actually click once if I click once I find that, all the bars are selected at once. If I click on the same bar twice, you would find that only this bar gets selected, which is the chosen one and you can go to formats and lets say color this in a different one, so there you go, so if you want to change only the color of a single bar, you can do that by double-clicking on that respective bar. So this is how you know a column chart can be made, a very useful chart as such, you can play with the set of designs in order to find you know how useful these chart utilities could be and how simplified they are. Now let us look at the other set of charts which we can make on this kind of a data.
So lets go back to sheet one and this time we will make the chart on lets say male and female employees in the organizations. So let me transfer this data from sheet one to sheet seven, and as we have discussed last time, I will quickly link it so this is only one link that I may have to copy. lets right click and paste it across the range, so, this is what I do for taking the references from the sheet one, now on this set of a data lets go back to the column chart and see what are the other set of option which are available. There is something called 3D chart, let me click here and the moment we do that as you can see you know this chart is actually made on a 3D axis.
Let us go back and play with another set of options, cylinders, charts, only the bars change, essentially a cone chart, this is a pyramid chart. So as you can see there are different kinds of options depending on what kind of visual appeal you want from this kind of chart. So ultimately if you look at, the basic philosophy remains the same, you can delete the series on the right-hand side, you can increase the font, this is known as the plot area, this is the chart area, you can do a lot of things in terms of being including the grid lines using the chart titles etc. so let us go back and look at another set of options. This is a line chart, a two-dimensional line chart and what it says is, lets say when we hover around this it says line charts are used to display trends over time, so when you have a time series lets say on day one you have done an X amount of business and on day two you have done Y amount of business, and that is over period of time, you can actually show that using line charts. So let me try to plot a line chart here, in this case, male and female, and though it is a line it is not kind of much use here.
There is other options of lines which is available. So at the end s you can see there is no pointers here, if you want some pointers you will also have that. If you choose line with markers. The third one is basically the pie-charts, this may prove useful in our case. So the pie chart in ms excels always displays the contribution of each value to the total. So basically the total is assumed and the contribution of each category is shown using a pie chart in ms excel, so lets try and make a pie chart in ms excel, so here is the pie chart, so as you can see the blue which is the larger portion Is the male, and the red ones here are the females. So it gives you clear visualization of what kind of chart you are making or what is the contribution as such here.
So this is very easy to interpret as well. So make pie chart in ms excel in which case you have different categories and contributions which you can really make. Now let us do some quick formatting Now let us format this pie chart in ms excel like the way we did for the column charts and we will do it fairly quickly here, we can click on the chart area and lets say we want to resize the chart area to a bit smaller one, so this is what the smaller size pie chart in ms excel could look like. Lets go to layout and change the legend, the legend as of now is on the right hand side, let me put that at the bottom. So legend at the bottom is the one which you need to choose, so here the legends are at the bottom, now this pie chart in ms excel may not be giving me an exact number in terms of, how many are the number of males or what percentage is the number of males until and unless I keep my mouse pointer on that respective pie so let me kind of add data labels here, and you can have it at the outside end. So, eleven are the number of males and eight are the number of females here. so again if you want to add chart titles you can also do that above the chart, chart titles, male and female in XYZ company.
So as you can see this chart titles looks a bit large, we can change this chart title and reduce the font size, to a reasonable one. We have also learnt about the plot area, so this chart is now looking very small as compared to the overall size of the chart. So we can actually play with the chart area, we can increase the size of this chart a bit by clicking on the plot area and reshuffling the sizes. this is how you know you can format a pie charts in ms excel in a very basic way. now lets look at the other set of charts that were available, things like bar charts, so if I select bar charts and click on this one you will notice that this pie chart in ms excel gets converted quickly into the bar chart.
There are different options of bar charts like what we saw in the column charts, like the cylinder chart or the cone chart, so all these options also you can explore whichever is really useful for your presentation or your report. The interesting thing in the other charts is also there is some things like the doughnut chart or a bubble chart. Let me actually open a doughnut chart for you. it is very simple you know, you just need to go ahead and choose the chart, and that how you know a doughnut will kind of open up. So if you think that these kinds of charts are making sense for you inset of your case, you can kind of select these charts. so principles of formatting remain the same and all the very best for your charts.
This has been a guide to the Pie chart in MS Excel. This post is a complete heads-up on how we can create a pie chart in ms excel. These are the following external link related to MS Excel so just go through the link.