G
gibasse
I am sorry for my yesterday bad explanation of the matter. I drew a line
chart starting from a table that contains the security values, for
instance the NASDAQ index, ranging from 1985 to date. Then I display
the chart for a specific date range.
At this point I draw manually, on the line chart, a trend line to
indicate the trend: imagine a line between two arbitrary points on the
chart depending on the evolution of the security.
My goal is to obtain, by some VBA procedure, the coordinates of the end
points (in the units of the chart, date and $) of the line I drew
before in order to set the relative position of the line and the chart
when I select other data range.
I hope to tried to explain a little bit better my question.
Regards
Giuseppe
chart starting from a table that contains the security values, for
instance the NASDAQ index, ranging from 1985 to date. Then I display
the chart for a specific date range.
At this point I draw manually, on the line chart, a trend line to
indicate the trend: imagine a line between two arbitrary points on the
chart depending on the evolution of the security.
My goal is to obtain, by some VBA procedure, the coordinates of the end
points (in the units of the chart, date and $) of the line I drew
before in order to set the relative position of the line and the chart
when I select other data range.
I hope to tried to explain a little bit better my question.
Regards
Giuseppe