Sorry to bump an old thread but I did a work around but revisiting this to do it properly I am getting the same error.
When I step through my code using F8 the charts are positioned perfectly under the tick labels of another chart.
When I run the code normally the new charts are not in the same place as when I stepped through the code. I just don't get how the result of the placement could depend if I step through or not. I think it must be a bug with excel. Has anyone else experienced this?
Here is the code:
This first part puts a stacked chart.
This part references the chart and calculates some x,y dimensions of the axis
This part then adds a pie chart and tries to place it under one of the tick labels
This works like a charm if I step throught the code but puts them in the wrong places when I just allow the code to run.
Bookmarks