Hi friends,
I'm trying to draw a chart which looks like an enhanced histogram chart:
1. I have 3 columns, A, B and C
2. I'll use C as bin to categorize A into different buckets. But I'm not
counting A, instead I'll sum B according to the bucket

for example:
input:
A B C
0.5 3.5 1
0.7 3 2
1.2 2.2 3
2.3 1.5
2.5 3

expected output:
C SumOfB
1 6.5
2 2.2
3 4.5
M 0

Is there a way to create the chart with existing capability in excel 2003?
If not, is there an add-in for download?
If I have to write VBA, what would it looks like?

Any sugesstion is appreciated,

Wei