+ Reply to Thread
Results 1 to 4 of 4

Charting data in a table with criteria

  1. #1
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Charting data in a table with criteria

    I have two problems I'm trying to solve with the same table.

    The goal is to create a 3D pie chart showing the numbers of each unique type of unit.

    Problem #1, in the table (shown below) I have both efficiency units and bed/bath listings. I have been able to extract the unique values of beds and baths but this method does not work for the term "Efficiency" since I'm triggering off of the backslash.

    Problem #2 is that I can create the unique values, i.e, "1 Bed", "2 Bed", etc., in the table but I cannot figure out how to chart the numbers of units that match each unique value.

    The formulas used currently are:
    C2: "=LEFT(A2,FIND("/",A2)-1)"
    D2: "=RIGHT(A2,LEN(A2)-FIND("/",A2))"
    E2: "=IFERROR(IF(COUNTIF(C$2:C2,C2)=1,C2,""),"")"

    I've also attached an example worksheet.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Charting data in a table with criteria

    I think I may have answered your #1 (look at the attached example with updated formulas in column C and E)

    For #2, I didn't build a chart or pie, but just made a quick pivot table which you can make a pivot chart. I have 2007 so don't have that feature.
    Attached Files Attached Files
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Re: Charting data in a table with criteria

    The pivot chart solved my problem completely...thank you!

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Charting data in a table with criteria

    You're welcome...Great news and thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract data from table into new table that matches multiple criteria
    By joplrw10 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-25-2016, 12:30 PM
  2. Replies: 3
    Last Post: 02-02-2016, 01:49 PM
  3. [SOLVED] Charting Continuous line of discontinuous data of a pivot table
    By bagullo in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-13-2015, 07:00 AM
  4. Replies: 9
    Last Post: 12-03-2014, 06:17 PM
  5. Establishing Multi-Criteria Template for Charting
    By mycon73 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 07-06-2011, 10:47 AM
  6. simple charting through Pivot table data
    By lavi in forum Excel General
    Replies: 1
    Last Post: 05-13-2010, 04:45 PM
  7. Including data in data table but not charting as a series or point
    By pepper76 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-01-2006, 10:25 PM

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