Convert scatter chart to bubble chart

[JayUSA]

Hello,

I would like to combine / overlay a bubble chart and scatter chart with straight connectors.

I understand that, without VBA, it is not possible to combine a bubble chart with a scatter chart.

Unfortunately, I am a VBA newbie, and so I cannot write my own code (though I can usually adapt code to my specific environment).

My question is: does anyone have VBA code to share that will convert a scatter chart series (x,y data in 2 columns) to a bubble-style chart (bubble radius in 3rd column)?

Cheers!

Jay

[JayUSA]

If anyone has a sample implementation, I can likely adapt it to my specific needs and worksheet design.

Cheers!

Jay

[JayUSA]

Thanks to Andy Pope, a sample implementation is now available at OzGrid. Type "Produce Hybrid Of Scatter Chart & Bubble Chart" into Google.

Cheers,

Jay