Pivot Table Help Needed.

**JonnyNYC90** · 10-27-2011, 02:57 PM

I am about ready to tear my hair out. I need some help creating a pivot table and charting it.

I have two columns. The first column (A) is Purchase Amount. It is a list of 4656 different numbers that are different purchase amounts.
The second column (B) is State. It is a list of what state each purchase came from, and once again it has 4656 values, for each purchase must have a state where it came from.

It looks something like this:
445.10 AK
39.40 AK
40.50 AK
204.20 AL
201.40 AL

...and so on.

How do I get this into a pie chart, where I can take the sum of all purchases in each state and compare them to the totals of other states?
I would like to create a chart where it would say that Alaska has $525 in total purchases, which comprises 10% of all sales of all states.

PLEASE HELP!

Thanks,
Jonathan

**MarvinP** · 10-27-2011, 03:22 PM

Hi Jonathan,

Find the attached that I created using 2010 and saved in 2003 format. I got a message that some formats may not be supported. See if it does what you need.

**JonnyNYC90** · 10-27-2011, 03:57 PM

Thank you, Marvin! I think I figured it out. I really appreciate your help!

Just a question: How did you get the percentages in Sum of Amt2?

Thanks,
Jonathan

**MarvinP** · 10-27-2011, 04:11 PM

Hi jonathan,

You drag the Amt down to the values section a second time. Then right click, in the pivot table, on the Amt2 and Excel 2010 has an option to Show As % of Total of Column. The newer versions of Excel are much easier than 2003. I was hoping you could see the answer and figure out how 2003 gets to the same answer.

**JonnyNYC90** · 11-01-2011, 12:10 PM

Marvin,
I'm sorry for taking so long to reply to your message. Thank you so much for your help once again! I have figured it out, and can now produce the reports that I need.

Thanks again,
Jonathan