Re: Produce Hybrid Of Scatter Chart & Bubble Chart
Actually the bubble chart is set to be by Area and my code does by width so that's why there was some differences. But there are always going to be differences as the appraoch is limited by the size you can set a data marker to.
I have updated the existing routine and added a new one. So now you have code for Area and Width sizing.
The whole process is restricted by the limit of marker sizes. There is no size smaller than 2 so particularly with the Area type the marker are just not small enough.
The other limit is that marker sizes happen in integer increments and do not have the unlimited adjustment to radius as bubbles do.
As to how to use this I think I confused you by providing too much information and not enough explanation.
I have provide code to do the resizing. The routines do require some minimal information such as,
• Range containing sizes
• largest marker size
• for ByWidth version smallest marker size
All the other formula and values on the worksheet are only there to illustrate what the code is doing.
Also attached xl2003 version, although AAE you might want to go and download the file format convertors for 2007.