If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Charting number of "name" occurences
Can someone tell me how I can chart the number of times a name occurs in a column? I would really appreciate it. Maybe just like a pie chart that everytime a new name is added it adds it in the chart, and everytime a name is repeated it just adds to the count of the name already added. Understand??? Can someone help me? Thank you! David -- silentop ------------------------------------------------------------------------ silentop's Profile: http://www.excelforum.com/member.php...o&userid=32271 View this thread: http://www.excelforum.com/showthread...hreadid=520231 |
#2
|
|||
|
|||
Charting number of "name" occurences
Put a header at the top of the column (e.g., "Name"), if you haven't
already. Select the column, and choose Pivot Table from the Data menu. Select the defaults or experiment with other settings, then when you get an empty pivot table frame in a worksheet, drag the Name field from the Pivot Table Field List to the Rows area, then drag it again (another copy, as it were) to the Data area. This provides a list of unique names, and a count of each name. Use this data to generate your pie chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "silentop" wrote in message ... Can someone tell me how I can chart the number of times a name occurs in a column? I would really appreciate it. Maybe just like a pie chart that everytime a new name is added it adds it in the chart, and everytime a name is repeated it just adds to the count of the name already added. Understand??? Can someone help me? Thank you! David -- silentop ------------------------------------------------------------------------ silentop's Profile: http://www.excelforum.com/member.php...o&userid=32271 View this thread: http://www.excelforum.com/showthread...hreadid=520231 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Return SEARCHED Column Number of Numeric Label and Value | Sam via OfficeKB.com | Worksheet Functions | 23 | January 30th, 2006 06:16 PM |
Report with set number of rows per page | Ken from Chicago | Running & Setting Up Queries | 7 | January 4th, 2006 02:42 PM |
Report with set number of rows per page | Ken from Chicago | Setting Up & Running Reports | 7 | January 4th, 2006 02:42 PM |
Report with set number of rows per page | Ken from Chicago | General Discussion | 7 | January 4th, 2006 02:42 PM |
Need Subforms? | AccessRookie | Using Forms | 7 | April 8th, 2005 09:30 AM |