Pie chart in a pivot table issue

Question

Hello,

So, I am having troubles getting a pie chart to look how I want from a pivot table in Excel. Basically, I have a column of criteria that are either true or false (I have made a separate column that denotes true as 1 and false as 0.) So let's say there are 10 entries with 7 trues. What I want it my pie chart in my pivot table to be 70% one color and 30% another. If I make a column chart and choose average values, I can get my column to be 70%, but I can't seem to get my pie chart to be 70/30.

I apologize if this is a little confusing; I've super simplified my whole project to this little piece that I need help with.

Thanks for the help!

Cody

Answer 1

Hello,

for a pie chart you only need two values. Create a pivot chart and drag the column with the TRUE/FALSE values into the Rows area. Drag it again into the Values area. This will give you a count of TRUE and FALSE. Change the chart type to pie chart. Right-click any of the Pivot table count results and then on Value Field Settings. Click the tab "Show Values As" and select "% of Grand Total".

Answer 2

Hi Cody,

I see you marked my post above as the answer, then unmarked it again. Does the solution not work for you? Do you need more information?

Please let me know how you get on.

Answer 3

Hi Cody,

I see you marked my post above as the answer, then unmarked it again. Does the solution not work for you? Do you need more information?

Please let me know how you get on.

Well, your answer works, but it didn't do what I had in mind. Turns out all I had to do was make multiple pivot charts from the same pivot table, and link together all the slicers. It was a little more work than I had in mind, but not too big of a deal.

Answer 4

OK, I see. So the scenario was a bit different from what you posted in your question. On the other hand, the question as asked ("So let's say there are 10 entries with 7 trues. What I want it my pie chart in my pivot table to be 70% one color and 30% another.") has been answered and that answer should be marked as such, so others can find it more easily.

Please mark it again.

Answer 5

OK, I see. So the scenario was a bit different from what you posted in your question. On the other hand, the question as asked ("So let's say there are 10 entries with 7 trues. What I want it my pie chart in my pivot table to be 70% one color and 30% another.") has been answered and that answer should be marked as such, so others can find it more easily.

Please mark it again. 

I apologize for the confusion, your reply has been marked as answer.