What are the ways for getting the visibility chart of incoming and outgoing people of a business concern? Please explain how can we make it.

First of all, know what dataset you want.
For example: name, department, function, entry date, leave date.
Then you create a list out of your HR system with above data and put it in an Excel table.
  How you present your analysis completely depends on the required reporting style.
Do you need only gross  totals, or also per department or function?   I give an example on gross totals: You can create a Pie Chart with only4 figures and use criteria fields to select the numbers of employees that came in, stayed or left the business.
I prefer to use the DCOUNTA formula to do the selection.
An example for2012:   1.
incoming (criteria: entry date >=01/01/2012 and <=31/12/2012 and leave date = empty) 2.
leaving (criteria: leave date >=01/01/2012 and <=31/12/2012 and entry date <01/01/2012) 3.
passing by: (criteria: entry date >=01/01/2012 and leave date <=31/12/2012) 4.
staying (criteria: entry date <01/01/2012 and leave date = empty or leave date >31/12/2012) Of course you can add extra criteria to your formulas, like department or function.
Please note that with above criteria I avoided people to be counted2 times, as well as in 'incoming' as in 'leaving'.
  The formula looks a bit like this: =DCOUNTA(A:E,A1,AA1:AB2) Where: A:E = table with employee data A1 = the field (name) you are couning AA1:AB2 = the criteria you are using   I hope this helps.....

Hi,   You can use Power Pivot Table and Chart.
PowerPivot is a recent tools and very powerful one for this cases.
Also, For adnvanced uers you can try Analysis Servcies.
  Regards;