+ Reply to Thread
Results 1 to 2 of 2

pivot chart to show status of customers with more than one condition

  1. #1
    Registered User
    Join Date
    10-17-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    18

    pivot chart to show status of customers with more than one condition

    Hi All!

    Just want to say thank you for reading this and for your time-really do appreciate all the feedback and help i get ;-)

    I have a list of customers of some who are now live and showing with "Active live datas" others may not have "Active live datas" but may have "Active ready Data" what I need to show is the stage of Data for the s238 Customer (original list of all the customers) I need to show
    The status for these customers:

    Eg to show how the different permutations of data set as below make up to the 238 customers?

    Active Live datas
    Active Ready datas
    Active TEST datas
    Active Suspend datas
    Inactive datas
    Terminated datas
    Migrated out datas

    At the moment I can only show this by putting the customer in the report filter of a pivot table and doing a COUNT of the "Total datas
    "

    but what I would like to see is a stacked graph to show the different data stages as above and somehow adding to 189 (this is the number of Customers of which have any value in data fields above- based on "Total datas" field. So the count in the graph would be 189 and it would display in the axis the values as the different permutations as the list above.

    I hope this is clear ;-)

    and I hope someone will have an answer!!!

    But I am perplexed in how to do this??
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: pivot chart to show status of customers with more than one condition

    see if the attached is what you want?
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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