If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Scatter Chart
HI
I am using an excel scatter chart for easy of clarity lets imagine i have 2 points on this chart. I would like to retrieve the x,y coordinates of these points so that I can draw a line using VBA between the points can anyone help? |
#2
|
|||
|
|||
Scatter Chart
Nino -
Here are some suggestions in increasing order of difficulty. A) Couldn't you connect the points with lines by formatting the series to have lines? B) In this post I provided a macro that drew a closed shape connecting the points in an XY Scatter chart: http://www.google.com/groups?selm=ut...%40tkmsftngp03 C) On this web page, I show how to get information about a plotted point that you click on, using chart event procedures: http://www.geocities.com/jonpeltier/...html#PointInfo - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Nino wrote: HI I am using an excel scatter chart for easy of clarity lets imagine i have 2 points on this chart. I would like to retrieve the x,y coordinates of these points so that I can draw a line using VBA between the points can anyone help? |
Thread Tools | |
Display Modes | |
|
|