Callouts on time series charts

Joined
Nov 5, 2005
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top