XY-Chart with 4 axes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...
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
 
In response to Tushar's suggestion:
Option 1: Create a line using the Line Tool from the Drawing toolbar.
Click to expand...
....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.
Click to expand...
....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!
 
...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!
Click to expand...
{shrug} If you say so.

--
Regards,

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