Pie Charting Percentages

[kdunn]

I need help and have tried everything. I am not very savy with pie charts and have exausted my own knowledge. Any help would be appreciated.

I have two sets of Data and would like to chart it in a pie, showing the percentages.

A B C D E F G
PE YTD 3 2 0 5 6 10 5
YTD # 422 431 445 855 414 186 581

I would like to chart the PE YTD based on each group, on the total of YTD# for all groups. I'm not even sure I am saying this right. Maybe this will help.

Total of YTD# = 3334

Group A = 3 / 3334 = .089

I want to chart the .089

 

[tactps]

Create a new row with the calculation you want to chart and chart that, not the source data.