Macro with multiple charts on the same page

kklewis

New Member
Joined
Dec 5, 2005
Messages
17
Im running a macro that loops through a variable and creates 3 charts on one tab. The first 2 charts are placed correctly and formatted correctly (I adjust the fonts of the x and y axes and the location of the legend), but the 3rd chart doesnt format correctly. When the program finishes running it looks as if the chart is in the wrong place (in the middle of the page overlapping the other 2 charts), but then when I scroll down to where it should be I find that it is located in the correct place but that it isnt formatted correctly.

If I step through the program it runs correctly and formats perfectly, but for some reason when I run the program all together it doesnt format correctly.

Any thoughts?
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,253
Members
412,709
Latest member
Rishu
Top