extract SeriesCollection(x) location...

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
 
T

Tushar Mehta

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
 

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