Results 1 to 7 of 7

Need help changing basic chart into a hierarchy chart/table in Excel 2010

Threaded View

  1. #1
    Registered User
    Join Date
    05-28-2014
    Posts
    15

    Need help changing basic chart into a hierarchy chart/table in Excel 2010

    Hey all,

    First and foremost, apologies if this has been asked numerous times or if it's really simple and I'm just missing something. I spent the last 2 hours browsing Youtube but I can't exactly find what I want, and at this point I'd rather not spend any more time doing "nothing" because I want to have something to show my boss before I go for lunch.

    Moving on...here's the situation and what I need:

    I currently have a table with multiple columns. The columns are as follows:
    CompanyName, PhoneNumber, FirstName, LastName, PositionTitle


    I have about 200+ companies in my list, and multiple contacts at each company. Basically, I want to be able to expand/collapse the CompanyName category. When I expand it, I want to see who all the contacts are with their first and last names, and their position titles.

    Eg:
    CompanyName
    FirstName, LastName, PositionTitle
    FirstName, LastName, PositionTitle
    FirstName, LastName, PositionTitle
    FirstName, LastName, PositionTitle
    CompanyName
    FirstName, LastName, PositionTitle
    FirstName, LastName, PositionTitle
    CompanyName
    FirstName, LastName, PositionTitle
    FirstName, LastName, PositionTitle
    FirstName, LastName, PositionTitle

    A total for the number of contacts per company would be useful too, because I will then have to rank the companies into 3-5 categories, based on how many contacts are there.

    Thank you very much in advance!

    Cheers
    Last edited by attaboy000; 05-28-2014 at 01:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to break dynamic links from table to chart in Excel 2010
    By GlennT in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-25-2014, 05:12 PM
  2. Excel 2010 Pivot Table Chart not doslaying Grand Total
    By dimi1963 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-27-2014, 06:15 AM
  3. Replies: 1
    Last Post: 01-27-2014, 06:18 AM
  4. Replies: 0
    Last Post: 01-14-2014, 02:00 PM
  5. Excel 2010 - Pivot Table Chart
    By jmancha in forum Excel General
    Replies: 5
    Last Post: 08-22-2011, 11:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1