+ Reply to Thread
Results 1 to 2 of 2

Combining data from two similar tables into one PivotChart

  1. #1
    Registered User
    Join Date
    05-27-2020
    Location
    Wales, UK
    MS-Off Ver
    2016
    Posts
    1

    Question Combining data from two similar tables into one PivotChart

    Hi, hoping someone can help.

    I have two tables on seperate sheets, tracking candidate journeys through a recruitment process.
    Both tables have a column heading "Status", holding the Candidate's current status.
    Some of the options are the same in each table (e.g. Testing) some are different (e.g. one will have "ProcessA_Interview", the other "ProcessB_Interview).

    I'd like to display both columns into one PivotChart so I can display the number of Candidates at each stage.
    So status' that show up in each table combine the figures from each table.

    I can't find a way of creating a relationship so any help would be great

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,183

    Re: Combining data from two similar tables into one PivotChart

    Please read the yellow banner at the top of this page on how to attach a sample file.

+ 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. Replies: 3
    Last Post: 05-17-2017, 09:45 AM
  2. Consolidate Pivot tables wth similar data
    By madmoo84 in forum Excel Charting & Pivots
    Replies: 30
    Last Post: 12-20-2016, 12:32 PM
  3. [SOLVED] Gather similar data in two tables
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-22-2016, 02:43 AM
  4. Matching Data with 3 Similar Tables(level)
    By henryyeo in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-18-2014, 05:57 AM
  5. Combining rows with similar data, not exact. Help!
    By Tony2009 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-25-2012, 03:14 PM
  6. Combining rows with similar data, not exact
    By Tony2009 in forum Excel General
    Replies: 4
    Last Post: 05-24-2012, 12:09 PM
  7. Replies: 2
    Last Post: 04-29-2010, 04:27 AM

Tags for this Thread

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