+ Reply to Thread
Results 1 to 2 of 2

Pivot chart help for multiple coloum data

  1. #1
    Registered User
    Join Date
    09-10-2014
    Location
    dubai
    MS-Off Ver
    10
    Posts
    1

    Pivot chart help for multiple coloum data

    Hi All,

    I am trying to give some graphical way for the below data

    SITENAME EMPLOYEE STATUS 1 STATUS 2 STATUS 3
    SITE 1 EMP 1 NEW ACTIVE RENEW TODAY
    SITE 3 EMP 2 RENEW TODAY ACTIVE RENEW TODAY
    SITE 2 EMP1 NEW ACTIVE RENEW TODAY
    SITE 3 EMP1 ACTIVE NEW RENEW TODAY
    SITE 3 EMP2 ACTIVE NEW ACTIVE
    SITE 1 EMP3 RENEW TODAY NEW ACTIVE
    SITE 2 EMP 1 RENEW TODAY NEW NEW
    SITE 2 EMP 1 RENEW TODAY ACTIVE NEW

    I want to do a graph like below

    1) For each site, for each employee, how many NEW, how many RENEW TODAY, how many Active.

    I tried my level best but not able to plot this. Could someone help me

    Regards

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,881

    Re: Pivot chart help for multiple coloum data

    Hello excelmalik and Welcome to Excel Forum.
    It might be easier to help if you uploaded an Excel file so that we could see the data in the columns.
    Also it may help if you could tell us some of the expected results, for example for site 2, emp 1 how many new, renew today and active should there be?
    Instructions for uploading an Excel file are given in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Multiple Rows Data into Single Coloum
    By Heart_Fragile in forum Excel General
    Replies: 7
    Last Post: 02-18-2019, 03:14 AM
  2. [SOLVED] I Need to Copy Paste One Coloum To Another Coloum With Key Words
    By Blek in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 01-23-2019, 04:23 AM
  3. [SOLVED] I Need to pick some word or text in one coloum to another coloum
    By Blek in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-27-2018, 09:27 AM
  4. [SOLVED] Creating multiple percentages from data in the same coloum?
    By Stickman001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2013, 06:43 PM
  5. Replies: 2
    Last Post: 08-05-2010, 11:40 AM
  6. separating data in one coloum to multiple coloumns
    By manwinderjit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2010, 07:01 AM
  7. Formatting Coloum Chart Data Tables
    By Usul in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-30-2006, 11:27 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