Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summary Report (OLAP kind)
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 |
#2
|
|||
|
|||
Summary Report (OLAP kind)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create summary of expense report? | Excel Worksheet Functions | |||
Can I create an order summary report in Excel? | Excel Worksheet Functions | |||
Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) |