extract SeriesCollection(x) location...

  • Thread starter Thread starter BK_Ziv
  • Start date Start date
B

BK_Ziv

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
 
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
 
Back
Top