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?
Hi TitansGo,
See the attached to see if this is what you want. I've used a new pivot column and had it show the percent of column total.
https://www.youtube.com/watch?v=5ZSPxO8PyIQ
Pivot Pie using Percent of Column Total.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks