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 ,
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/