Hi,
I have a line chart that shows a company's stock price over the course of a year. I use callouts (autoshapes) to label days when important things occurred. Is there a way (using VBA) to position callout so they point to an exact day on the chart?
I can create the callout easily enough, but I don't know how to get the coordinates of a point on a line chart. It would almost be like when you add a label and position it right on the point. How can I get these coordinates?
Thanks,
Paul
I have a line chart that shows a company's stock price over the course of a year. I use callouts (autoshapes) to label days when important things occurred. Is there a way (using VBA) to position callout so they point to an exact day on the chart?
I can create the callout easily enough, but I don't know how to get the coordinates of a point on a line chart. It would almost be like when you add a label and position it right on the point. How can I get these coordinates?
Thanks,
Paul