Ok, well, I have a related question then that might help me. I'm executing this statement several times to create a legend
ActiveChart.Pictures.Inser
With Selection
.Border.LineStyle = xlNone
.Shadow = False
.Left = 180 + (ChartIndex * 60)
.Height = 7
.Width = 7
.Top = 15
End With
1. Can I load this .bmp into memory once and then just insert it?
2. Sometimes in Excel 2007 I get an error trying to insert the .bmp. Next time or so after I run the macro it works OK.
Main Topics
Browse All Topics





by: harfangPosted on 2009-10-19 at 15:15:08ID: 25609476
Hello newbie-netter,
I'm afraid there isn't. Custom templates will not record something like intermittent markers, and your code has additional logic to deal with various densities. This being said, this is exactly what Excel VB is meant for. I have used code to generate, adjust, and tweak charts many times. This is what offers the most flexibility.
(°v°)