Summary Report (OLAP kind)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

How can I create a report which shows me:

Num_of_Years - Count
------------------------------
1 - 2
2 - 4
3 - 3

(The above needs to be show in Graph format)

We have the following data source available in Excel is:

Emp_Name - Experience_In_Years
-------------------------------------------
John - 3
Mike - 2
Adrian - 2
Jill - 3
Smith - 1
Tom - 2
Jerry - 1
Stella - 2
Jim - 3

Please help.

Regards,
Kamlesh
 
Hello Again :-)

I got this through Pivot Table/Chart option.

If there's is any other method other than Pivot Table, then please share
with me.

Regards,
Kamlesh
 
Back
Top