Provide one bar chart for each hospital. This means seven charts for all seven hospitals. Then, provide bar chart to compare data from hospital one with data from other six hospitals.
E.g. 1-Barwon hospital( one bar chart with all data)
2-Barwon Hospital( 8 bar charts to compare data with others. e.g implementation phase at Barwn hospital in comparison with implementation phase at others hospitals etc.
Use macros in excel please.
I’m looking for someone who can use attached excel worksheet to analyse/graph the data and then draw some conclusions from this. I believe it will require skills such as utilising and macros in excel, as I will be receiving new raw data throughout the project so need to be able to run it through the spreadsheet automatically without having to re-enter it manually each time something new or updated is received.
1- I need all data to be listed and graphed for each hospital.
2- Compare each data with other hospitals. e.g hospital 1 data is compare in graph to other data.
3- Use macros in excel.
4- I need conclusion.(this data will be used to implement MEDICAL RECORD SCANNING.
Attachment:- book1.xls