Custom charts in EXCEL using Shapes
Posted on 2003-12-12
I am trying to create a plot in EXCEL using shapes from VBA (after giving up on the Chart object because it is too restrictive).
Using shapes gives you absolute control - The problem I have is that the basis for the chart is an XY scatter with up to 15k points - Chart can plot this quite quickly, but doing it in a for..next using Shapes.AddShape(...) is slow.
BTW, I have considered using a hybrid approach, i.e. plot XY with the Chart object and then use shapes to plot over it, but this brings its own problems - e.g. there is no .top or .left for a Point object (which I need to anchor shapes to), so...
- is there fast way in VBA to plot many shapes - would have been nice if you can use the .AddShapes with an Array....
- would be API calls be much faster?