pie charts combined with bubble graph in excel-vba error

Question

I need to create pie charts in bubble graph in excel. I have found a way to it: http://alesandrab.wordpress.com/2013/02/19/create-a-bubble-pie-chart-or-world-map-pie-chart-using-vba-and-excel-charts/

My Data:

When I run the code I took a error:

Pls help.

Answer 1

I had the same problem with this one. Turns out that it was the double apostrophe that was causing the issue since I copied and pasted the code. I just had to delete and retype the apostrophes and it worked. It may have been the same case for you.