#1
|
|||
|
|||
Analysis in Excel with chart
Hello,
I want to do analysis in Excel with bar chart or pie chart. I will explain what ı want. In Sheet 1: There are datas in detail. In Sheet 2: There should be number of people in training and training type. But there are training types we should seperate. For exampe in sheet 1; training type consists of MLE, LLE and LLE+CCQ. These are the name of training type. My manager want to show the data in monthly breakdown both training type and number of people. Could you help me for this thread? Best regards&Thnks. |
#2
|
|||
|
|||
Is there anybody help to me?
|
#3
|
|||
|
|||
This seems like it would be a good application for a pivot table.
|
#4
|
|||
|
|||
Quote:
Also as far as ı detail in sheet 2, before chart or pivot table, there should be number of people from Sheet 1 automatically. (table reguire e formulas for calculation also.) Then pivot table should be done. |
#5
|
|||
|
|||
Pivot tables are as intuitive and easy as they are powerful. The best way to learn is to play around with them. I'll get you started though...
In a new sheet...Insert Pivot Table Enter the data range from Sheet 1 Press OK. In the Pivot Table Field list, check Training Type and Training Start Date. They will appear as Row Labels. Click and drag Name Surname to the Values Box. It will appear as Count of Name Surname. Right click on any of the dates that now appear in the pivot table. Select Group. Highlight months and years. Click OK. |
#6
|
|||
|
|||
Quote:
Could you do a formulation for sheet 2 and then we can use a pivot table? Is it possible? |
#7
|
|||
|
|||
Let me start you off. I had to add some dummy initials for surnames to make it work since you had left that blank. Play around with it and see if you can figure it out to suit your needs.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What if Analysis | fm2406 | Excel | 0 | 10-20-2015 09:47 AM |
Delay Analysis | ketanco | Project | 3 | 03-15-2013 01:06 PM |
Analysis of states and income levels | knownunknown | Excel | 1 | 01-22-2011 06:35 PM |
How to apply budget for earned value analysis | ttorneby | Project | 2 | 06-03-2010 04:52 PM |
Analysis of Amount based on following criterion. | aligahk06 | Excel | 1 | 04-24-2010 10:34 AM |