extract SeriesCollection(x) location...

Is there a way to extract the x and y values in "points" from a data
point in a SeriesCollection?

I want to draw a line from one point to another and want the line to
change as the data points change and are updated in the chart.

I assume that Excel must know where to put a data point on the chart in
"points" from 0,0 in the upper left corner. If not how else does it
know where to draw them?

Thank you,
BK_Ziv



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

You don't need to worry about the window coordinates.

Put the x and y values of each of the 2 points you want to connect in
worksheet cells. Now, plot this data set. When the x or y values
change XL will automatically update the chart.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <BK_Ziv.uawsc@excelforum-nospam.com>,
BK_Ziv.uawsc@excelforum-nospam.com says...
> Is there a way to extract the x and y values in "points" from a data
> point in a SeriesCollection?
>
> I want to draw a line from one point to another and want the line to
> change as the data points change and are updated in the chart.
>
> I assume that Excel must know where to put a data point on the chart in
> "points" from 0,0 in the upper left corner. If not how else does it
> know where to draw them?
>
> Thank you,
> BK_Ziv
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>
>