Results 1 to 2 of 2

Pivot Chart depicting percentage of total of single colum

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2015
    Location
    Alabama
    MS-Off Ver
    Excel 2013
    Posts
    29

    Pivot Chart depicting percentage of total of single colum

    I have tried to figure out how to get a pivot chart that depicts the percentage value of each category (e.g., FARM, MARKET) of the total for all categories within one column. In reference to the attached example of both the problem and desired result, I would like to know the percentage for each supplier of the total value of all suppliers and have this visualized in a pie chart. Is there anyway a pivot can accomplish this? Or am I to use normal tables?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Depicting numeric ranges as single value
    By Bumblbree in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-22-2016, 05:42 PM
  2. Pivot table - how to show percentage of total?
    By GoldbergJesse in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-19-2015, 03:31 PM
  3. Pie Chart from Single Percentage Cell
    By AllanTheCowboy in forum Excel General
    Replies: 1
    Last Post: 07-11-2015, 11:10 PM
  4. [SOLVED] I want to remove the percentage of row total in the pivot table
    By Shellybelly in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-08-2014, 06:51 AM
  5. Need to chart both amount and percentage from a cell as total
    By Taiter in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-25-2013, 09:50 AM
  6. Pivot: Percentage of Subtotal and Total
    By GMANFG in forum Excel General
    Replies: 2
    Last Post: 02-14-2010, 07:06 PM
  7. Replies: 1
    Last Post: 10-28-2005, 01:05 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