-
Sleeper: Aggregated charts
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
-
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
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules