Part -23 – Graph and Chart Formats
Download Excel Graph and Chart Formats Templates
graph and chart formats (without solution)
graph and chart formats ( with solution)
Transcript For The Video – Graph and Chart Formats
Graph and Chart Formats – Another set of presentation that we did was on the graphs and charts of bar chart, pie chart, line chart, area chart, presentation template, circular diagram, and graphic organizers these set of numbers Marketing, IT, Finance, Support, Employees as well as male and female employees we had earlier made the column charts and the pie charts. let us extract that chart from sheet number 7 and the way of doing this could be we can just copy this chart by right clicking on this chart and take it to sheet one and right click and paste it so what we find is that this chart is transferred from sheet 7 to sheet 1. So there is another copy at sheet 7 which is still left because we have used the copy command likewise let me copy this pie chart by right clicking on the pie chart area and transfer this to sheet one. So these are the two set of charts which we have so let me just decorate it a bit so it comes good in terms of the final printout. I can increase the width so that I can align to the one which I have male and female in the XYZ company I can also reduce the fonts so that it becomes really interested and proportionate. Now the another thing which we can also do is that we can actually create a pivot table for various insights now this pivot table was actually created in sheet 9 and we can also use these kind of pivot table for our exercises, so the pivot table that we want to or we may want to use is department wise male and female so we can use this we can copy this table and we can take it to the sheet one we can paste as value and we can look at formatting this likewise there is another set of formatting table that we have earlier made department wise sum total of annual salaries so we can copy this as such and take it to sheet one. and we can have paste value. So let us look at formatting these tables here the row label here is basically the department and the one on the right hand side is the count of gender. See the department is not visible so we can increase the width of column by double clicking here so we find that the department is now clearly visible now if you look at Finance it is divided into two genders male and female likewise IT male and female, marketing male and female and support male and female it is very difficult to, at this stage to clearly see the difference between department and male and female here so what we can do is we can really look at using the option which is here on the alignment so if you see on the top there is something called let me press this and show what happens once I increase the indent you may like to see that you know this male and female both are indented towards the right hand side likewise let me do it again for IT male and female Marketing and Support so by this we can clearly understand and see that under finance there are two subheadings under IT there are two subheadings in order to bifurcate this further we can actually bold this by going to font or we can actually use the shortcut CTRL+B. So we can bold this and final grand total is basically 19 so I can look at using specific case of borders may be using this kind of border top and double bottom border so it gives you a grand total of 19 and the only thing that probably is left here is count of genders and department to be highlighted so let me highlight this I will choose set of my colors which I want and that’s it so this table gets bit formatted likewise I may like to kind of format this small table here, I will go in a similar way, I will just make a grey font and since Finance, IT, Marketing and Support, the number corresponding to these are percentages I will convert these into percentages and may be use a single decimal and likewise you may like to see that here this sum of percentage of total annual salary is not visible in a single cell so like we did before we may like to wrap the text here so we can use this wrap text option so it clearly divides this into two columns which are clearly visible likewise look at the grand total and I will choose the same option as I did here for the grand total so now you may see that these are reasonable presentation and last but not the least I may like to bold these as well so I am done with the set of presentation for the report.
