Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2016, 01:13 AM
Aseren Aseren is offline Analysis in Excel with chart Windows 7 64bit Analysis in Excel with chart Office 2010 64bit
Novice
Analysis in Excel with chart
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Analysis.xlsx (97.7 KB, 12 views)
Reply With Quote
  #2  
Old 02-23-2016, 04:47 AM
Aseren Aseren is offline Analysis in Excel with chart Windows 7 64bit Analysis in Excel with chart Office 2010 64bit
Novice
Analysis in Excel with chart
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default

Is there anybody help to me?
Reply With Quote
  #3  
Old 02-23-2016, 08:04 AM
gebobs gebobs is offline Analysis in Excel with chart Windows 7 64bit Analysis in Excel with chart Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

This seems like it would be a good application for a pivot table.
Reply With Quote
  #4  
Old 02-23-2016, 10:49 AM
Aseren Aseren is offline Analysis in Excel with chart Windows 7 64bit Analysis in Excel with chart Office 2010 64bit
Novice
Analysis in Excel with chart
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
This seems like it would be a good application for a pivot table.
How do we do? I dont know, could you help with pivot table?

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.
Reply With Quote
  #5  
Old 02-23-2016, 12:36 PM
gebobs gebobs is offline Analysis in Excel with chart Windows 7 64bit Analysis in Excel with chart Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #6  
Old 02-24-2016, 12:46 AM
Aseren Aseren is offline Analysis in Excel with chart Windows 7 64bit Analysis in Excel with chart Office 2010 64bit
Novice
Analysis in Excel with chart
 
Join Date: Feb 2016
Posts: 12
Aseren is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
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.
Thnks for your help but, in sheet 2 we should show the numbers of people in monthly breakdown. In pivot table only show us the case in table. Maybe ı may not do what you say.
Could you do a formulation for sheet 2 and then we can use a pivot table? Is it possible?
Reply With Quote
  #7  
Old 02-24-2016, 06:42 AM
gebobs gebobs is offline Analysis in Excel with chart Windows 7 64bit Analysis in Excel with chart Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Attached Files
File Type: xlsx Analysis.xlsx (101.3 KB, 15 views)
Reply With Quote
Reply

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
Analysis in Excel with chart 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
Analysis in Excel with chart 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft