![company expense report template excel company expense report template excel](https://s2.studylib.net/store/data/010412947_1-95d85f3fdaff4e45ae09515a2608068f-768x994.png)
Choose Ongoing in the drop down list and see the percentage change in the bar.The advantage is, that if you insert a new entry, it will automatically create the serial number and drop-down list for work status.You will see the template converted to a table.Here, I’ll show you how to use the template of Section 1 as a table. Using Excel Table to Make Daily Activity Report in Excel Thus you can make a daily activity report for monitoring the work progress.Ģ. As we take the rounded percentage, you will see 63% in the bar as a result. If you change any of the work statuses, you will see the percentage change in the bar.Īs we changed the work status from ongoing to done, now there are 5 works done out of total 8 works, which means 62.5% of the work is done.Format and set the orientation of the bar according to your convenience.And then right-click on the Text Box and select Fill > No Fill.Hit ENTER and you will see the percentage in the Text Box.We stored the formula of percentage in cell G1 previously, so we put the value of it in the Text Box. This formula will simply provide the value of the percentage of work done in the Text Box. Then type the following formula in the formula bar. Put the Text Box in a suitable position and select it.The green part of the bar represents the fraction of work done. Similarly, set a color of your wish for the left part of the bar.You can choose any other color according to your wish. Then right-click on the blue part of the bar and select Fill > Green.
![company expense report template excel company expense report template excel](https://cdn.shopify.com/s/files/1/0090/2125/9831/files/Expense_Tracking_Worksheet_Templates-1.png)
After that, resize the bar and drag it to a suitable position.Set Series Overlap and Gap Width to 100% and 0%.Again, right-click on the bar and select Format Data Series….Move up Series2 by clicking on the marked icon in the following figure.In the Edit Series dialog box, set Series values as 1 and click OK.Right-click on the blue bar and click on Select Data.Hit ENTER and you will see the percentage of work done in that cell.To see this value in percentage, go to the Number ribbon and select Percentage.
![company expense report template excel company expense report template excel](http://www.bluelayouts.org/wp-content/uploads/2014/01/expense-report-template-ms-word-08.png)
After dividing, we will get the fractional value of the ratio between work done and total work. The COUNTA Function will count the number of cells through the range G6:G13. The COUNTIF Function will count the number of times “ Done” present in the Work Status column.
![company expense report template excel company expense report template excel](https://db-excel.com/wp-content/uploads/2017/03/Free-Expense-Report-Form-Excel.jpg)
The IF Function will leave the serial number entry blank if there is no entry in the Work Title column. We are using this formula so that we can put a serial number for each work automatically.