PivotTable or SubTotal Macro 1

[Lil8]

I am trying to convert the following into Pie chart
so that It will dsiplay the Total Sales for each SalesPerson
The list has 100 s of entries so I tried top use a Pivot Table to add up the sales for each SalesPerson and then try and display the results Pie Chart without success.

SalesPerson TotalSales

1 252
2 20
1 12
1 120
3 50
4 41
1 44
5 78

I have thought of doing a SubTotal for each SalesPerson but would have to do this manually. Is there any other way of doing this please ?

 

[SkipVought]

Hi,

You said that you tried using a PivotTable?

Did you try selecting PivotChart using Sum of TotalSales? Works just fine!

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244