Hello,

I am trying to add arrows below a chart based on dates along the x-axis using vba. Using Application.WorksheetFunction.Match on the raw data, I am able to get the serial position of the point on the chart. Then using SeriesCollection(...).Points(...).Left gives me the horizontal location. This works great if I create the arrow within the ChartObject. However, if I create arrow outside the ChartObject, it is just slightly off, no matter where the chart is located within the sheet (the delta is always the same) - and the final position must be exact. The reason I need it created as a shape separate from the ChartObject is that I would like to be able to manipulate the arrow using the arrow keys, and this appears to be impossible for shapes created within charts.

Note that when creating the arrow outside the ChartObject, I add the .Left and .Top position of the ChartObject itself to account for the position of the chart within the sheet.

Here is my code:

Please Login or Register  to view this content.
Any help would be greatly appreciated. Thank you!