PDA

View Full Version : Aggregated charts



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

mdmackillop
06-24-2005, 04:15 PM
Hi Zwasdl,
Welcome to VBAX.
Sorry, I don't quite understand your question. If you can post an example, it will probably help in securing an answer. Click on Go Advanced below the message box, and on the Manage Attachment button. You can attach Zip and some other format files.
Regards
MD