+ Reply to Thread
Results 1 to 3 of 3

Pivot Table/Pivot Chart Help

  1. #1
    Forum Contributor
    Join Date
    06-15-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    100

    Pivot Table/Pivot Chart Help

    Hi Guys,

    Got a pivot table where I've added in a calculated field (it's an if formula to allocate a customer to a group) but now i'd like to create a chart from this (most probably a pie chart) showing how many customers are in each group. But I can't seem to move the calculated field in to a position to show this. Is there any way to successfully do this?

    The only way i've worked out so far is by making a pivot of the pivot, which is obviously less than desirable..

    Any help is greatly appreciated

    Thanks very much.

  2. #2
    Forum Contributor
    Join Date
    06-15-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Pivot Table/Pivot Chart Help

    I can upload a sample workbook if needed..

  3. #3
    Registered User
    Join Date
    06-14-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Excel 2013
    Posts
    48

    Re: Pivot Table/Pivot Chart Help

    That would be useful

+ 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