Pie chart with summation of data

**java22** · 01-31-2012, 10:42 PM

I have a data sheet with many rows - each row has amount and state where the sales was made like :

amount State
100 AZ
200 CA
300 AZ
400 TN
600 AZ
100 CA

and so on . I would like to create a summation of amount sold by state and then show that in a pie chart . In the example above
total sale for 1000 AZ
300 CA
400 TN

I appreciate any help . I need this for my work .

**dilipandey** · 01-31-2012, 11:24 PM

Hello and welcome to the forum.

See the attachment which has the example shared by you along with the solution

Regards,
DILIPandey

<click on below 'star' if this helps>

**java22** · 01-31-2012, 11:50 PM

thank you - I see the data you created - by pressing right click I can not get the pivot table . I guess if I knew how to do the data summed as you have done I can then create the pie chart .

**java22** · 01-31-2012, 11:52 PM

I get a message unsupported pivot style - since I use MAC version - any ideas ? it also opens the file read only

**java22** · 01-31-2012, 11:53 PM

I see now . I get a message unsupported pivot type - since I use MAC version - any ideas ? it also opens the file read only

**dilipandey** · 02-01-2012, 12:13 AM

Hi Java22,

You need to right click on pivot table and Refresh whenever you add any new data in column A and B, but since you are using MAC, I would have no idea about it.

Regards,
DILIPandey

<click on below 'star' if this helps>