+ Reply to Thread
Results 1 to 2 of 2

Show in a pivot chart only some sub-percentages from pivot table

  1. #1
    Registered User
    Join Date
    11-17-2011
    Location
    Greece
    MS-Off Ver
    Excel 2003
    Posts
    5

    Show in a pivot chart only some sub-percentages from pivot table

    Hello.
    For example we have the following table keeping track of the result ( success(V) or fail(X)) for some recurring events:
    tDGIC.jpg
    and the respective pivot table:
    5KG80.jpg
    where results are shown as percentages of their parent total

    What matters to me and needs to be shown in the chart are only the percentages of their parent total just for result type V, for each event, that is the "success rate" of each event. I would expect then a chart with x-values "task1","task2" and the respective y-values 66,67% and 50%.
    Is this possible?
    Thanks in advance.

    p.s. inside the post I have inserted two pictures, but two more pictures appear as attachments which I don't want them to
    Attached Images Attached Images
    Last edited by kikonas; 02-25-2016 at 11:46 AM.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Show in a pivot chart only some sub-percentages from pivot table

    You could move result to columns and then hide the X column.

+ 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. Pivot Report doesn't show current records but they are in pivot table
    By dixiecricket in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-16-2015, 11:25 AM
  2. Want to show source data for pivot chart in a table next to it
    By kmarie630 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-29-2014, 11:07 AM
  3. Replies: 0
    Last Post: 03-17-2014, 08:41 AM
  4. [SOLVED] Pivot Table Summary -- Part #'s do not show in Pivot but data is in worksheet
    By maryren in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-19-2013, 10:51 AM
  5. How to show full totals in Pivot chart and table when you filter on one customer?
    By newbieexcelgirl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 06:30 PM
  6. [SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)
    By Gideon1973 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2012, 10:57 AM
  7. [SOLVED] How do I show summary totals from a pivot table on a bar chart
    By Colleen T in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-21-2005, 10:06 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