zwasdl
06-24-2005, 10:30 AM
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 suggestion is appreciated,
Wei
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 suggestion is appreciated,
Wei