Excel Macro, Dashboard, Calculations and Graphs
Budget: $30 – $250 USD
This project is to create macros , calculations and graphs
Sheet 1 should calculate certain fields and this result of this should be performed and outlined in The totals sheet and Graphs sheet. This should be able to be copied for different systems. Sheet 2 – is just a different version of sheet 1 but I would like to show this In graphs if someone has completed there task Yes Or No and who is holding this us. Highlight the cell in Red by defuat Sheet 3 - When I run the Marco I need to show the values form the sheets and different systems. Sheet 4 should displays graphs for all systems, How many documents drafted, How many documents have been reviewed, How many documents approved, Late tasks etc. All the table in attachment 1 should be visible in the graphs. Attachment 2 is an example of how I want this done. However, I would Like to use attachment 1. This should be all done by using marco buttons Again I would like to repeat this for multiple systems, therefore, if I copy sheets etc this should work automatically. This is the main requirement Attachment 01 has red cells to show you the information I would like.
Also I would like this to look good and have a nice dashboard
Sheet 1 should calculate certain fields and this result of this should be performed and outlined in The totals sheet and Graphs sheet. This should be able to be copied for different systems. Sheet 2 – is just a different version of sheet 1 but I would like to show this In graphs if someone has completed there task Yes Or No and who is holding this us. Highlight the cell in Red by defuat Sheet 3 - When I run the Marco I need to show the values form the sheets and different systems. Sheet 4 should displays graphs for all systems, How many documents drafted, How many documents have been reviewed, How many documents approved, Late tasks etc. All the table in attachment 1 should be visible in the graphs. Attachment 2 is an example of how I want this done. However, I would Like to use attachment 1. This should be all done by using marco buttons Again I would like to repeat this for multiple systems, therefore, if I copy sheets etc this should work automatically. This is the main requirement Attachment 01 has red cells to show you the information I would like.
Also I would like this to look good and have a nice dashboard