BobBarker
04-14-2011, 09:57 AM
Hi.
I am trying to create a bubble chart in purely VBA. The reason why I'm doing this is because I want to put text labels on each bubble and Excel only allows me to put the series name, which ends up being everything. So rather than adding in series row by row, I've decided to make a script that does it for me.
I've managed to get my code to run, sorta. The problems I'm having are that it is skipping rows for some reason and also I don't know how to specify the size column.
I've attached my code below. Any help is appreciated. I got really close this time!
[EDIT] I now realize that it is fetching all the rows properly! The problem is that I'm not specifying the size column. Still don't know how :/
I am trying to create a bubble chart in purely VBA. The reason why I'm doing this is because I want to put text labels on each bubble and Excel only allows me to put the series name, which ends up being everything. So rather than adding in series row by row, I've decided to make a script that does it for me.
I've managed to get my code to run, sorta. The problems I'm having are that it is skipping rows for some reason and also I don't know how to specify the size column.
I've attached my code below. Any help is appreciated. I got really close this time!
[EDIT] I now realize that it is fetching all the rows properly! The problem is that I'm not specifying the size column. Still don't know how :/