Excel 2007 : Need help with a pie or column chart..

[J0rdan]

Hey guys.

I have 2 columns in my excell sheet. The first one is "type", the second one is "amount".

For instance:


extended $14.70
VIP $4.70
extended $14.70
extended $24.70
extended $14.70
VIP $4.70
extended $14.70
VIP $4.70
extended $10.20
VIP $4.70
dollars $9.70
dollars $14.70

There are about 2000 entries.

I want to make a chart that shows me how much total sum I got for extended, how much total vip and how much total dollars. Is there any way I can do that?

I can't seem to figure it out! Thanks.

[dmang1]

Hello Jordan,

Yes - a Pivot Chart.

Please find example workbook attached.

Cheers,
Diana