Pies and Bubbles together

[pickslides]

Hi all, I have been following the following articles by Andy Pope to combine many pie charts within a bubble chart.

https://alesandrab.wordpress.com/201...-excel-charts/

and

http://www.andypope.info/charts/piedatamarkers.htm

My sheet has a small piece of VB code that is not running. I cant figure out why?

MQ.

[Kaper]

Starting debugging:

There are other references to charts in the code than in the sheet.
no chtPieMarker at all,
ChartObjects(1) is a pie chart while shall be chtMarker one

Correct to:

Please Login or Register  to view this content.

This starts working, but causes an error because you run loop which is too long:

Please Login or Register  to view this content.

while your data extends only to H7
Use only existing data:

Please Login or Register  to view this content.

This runs to the end but visual effect is not perfect, namely aspect ratio is wrong (ovals instead of circles pasted into main chart).
Either correct manually aspect ratio of whole chtMarker drawning area, or do it in the code.

Final: at the end of the code you again switch off screen updationg - it has no effect because: 1) is already switched off 2) once the code stops screen updating is switched on.
intPoint variable is unused

So the code at this stage (code is never final - probably still more debugging needed :-P ) could be:

Please Login or Register  to view this content.

[pickslides]

Hi Kaper, thanks for reply, I have used your suggestion and you are right there is more debugging to be done.

Will start again from scratch.