XY-Chart with 4 axes

[Guest]

I have: data point P1(x1, y1); uses the primary X-Axis & primary Y-Axis, and
data point P2(x2, y2); uses the secondary X-Axis & secondary Y-Axis.

Can someone please tell me how to join P1 and P2 by a straightline ??

I've tried couple of ideas with no success !

Thank you.

 

[Tushar Mehta]

I have: data point P1(x1, y1); uses the primary X-Axis & primary Y-Axis, and
data point P2(x2, y2); uses the secondary X-Axis & secondary Y-Axis.

Can someone please tell me how to join P1 and P2 by a straightline ??

I've tried couple of ideas with no success !

Thank you.

Option 1: Create a line using the Line Tool from the Drawing toolbar.

Option 2: Add a data point to series 1 such that it uses the primary
axes coordinate system but is located exactly on top of the point on
the secondary axes. Now, for series 1 choose the XY Scatter subtype
that includes a connecting line.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

In response to Tushar's suggestion:

Option 1: Create a line using the Line Tool from the Drawing toolbar.

....Difficulty: unless one can (somehow) assign the start point of the "line"
from the Drawing toolbar as P1(x1,y1) and its end point as P2(x2,y2).
Otherwise, changing the coordinates of the points P1 & P2 in the worksheet
would not automatically adjust the line joining P1 (uses the primary axes)
and P2 (uses the secondary axes).

Option 2: Add a data point to series 1 such that it uses the primary
axes coordinate system but is located exactly on top of the point on
the secondary axes. Now, for series 1 choose the XY Scatter subtype
that includes a connecting line.

....Difficulty: would not work! because the added point would be out of scale
and consequently the joining line would be the wrong line and not the
intended one!

 

[Tushar Mehta]

...Difficulty: would not work! because the added point would be out of scale
and consequently the joining line would be the wrong line and not the
intended one!

{shrug} If you say so.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions