newbie: Getting the X and Y positions

  • Thread starter Thread starter Nicky
  • Start date Start date
N

Nicky

Hi all.

I've searched through the groups and can't seem to find anything that
helps me. I've created an XY Scatter chart and need to draw a line
from a point in one series to a point in another series. Currently,
i'm able to get the X value of points, but not the x and y position
which I need to draw my line. I'm just a newbie when it comes to VBA,
so I appreciate any help.

Thanks, Nicky
 
Have you considered simply adding a new series containing
the two points - one from each of the existing series?
This series would not have markers, just the straight line
type. This would in effect draw a line between the two
series.

Regards,
Greg
 
And the advantage to Greg's suggestion is that, if the axis scales
change, the added series would move accordingly, while the drawn line
would sit dumbly where you drew it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

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

Similar Threads

Charts Having X Axis Scaled Using Calendar Weeks 4
Finding Intersection Points between different lines 1
Scatter Plot Question - adding straight lines 0
Graphing a bounded region with a twist? 1
Is there a way to draw a vertical line from a point on the chart line to the bottom of the chart 7
Is there a property to get the values for a point in a chart series? 6
Charts -- drawing arrows to points 2
Tooltip on XY scatter chart 2

Back
Top