Populate Mark Number with airSlate SignNow

Populate mark number

welcome to all in our channel photo in this video we will discuss how to make daily mark in excel sheet so here is some data whose telemark we are going to draw for terry mark there is the sequences of fives and ones so we make fives and ones of the frequency for that we need some formulas we go through the formulas so watch the video till end and once you practice so let's start for the fives we put a formula here equal to floor mat select the floor mat and choose the cell of the frequencies and put a comma after putting a comma you enter 5 and close the bracket and then enter in 14 we got two fives the value of two fives is ten that scan here so we copy this cell as like to all cells so all created all files are created automatically and for once we also choose here a formula and the formula is equal to mod select the mod option and then select the frequency cell which is 14 then put a comma and enter five and then close the bracket and then enter you got five ones in frequency 14 and then you copy and drag down the sign for all cells you got them once for all so select there make it bold and increase the size of the values after getting this we need a chart for that select the cells of fives and ones and then go to insert and then choose 2d bar this one it will show you fives and ones in separator form so your do some changes in this bar chart to delete chart title delete this one delete also this one and you see here this is three ones which is here so it become reverse so we need to reverse the axis option for this you have to select this one and go on format select the format selection and there you have a option bar in which you go on access position and tick the check box of categories in reverse order after you're checking it take it it reverse form comes in reverse form and then you cut it and there is a gap and then you delete the axis we have no needs of axis here there is a gap between the bars so we need to remove the gaps between the bars you go through format format selection and then you go in the bars option here is a option of gaff with you make it zero so the gap between the bus become zero there is one option also there is no borders between the bars so we put a border between the bars for this we go in color box we fill the border we fill automatically there is color is white so make it black and then it appears it not appears here so we go another so here is the...