XY-Chart with 4 axes

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.

In article <[email protected]>,
[email protected] says...
> 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

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" wrote:

> In article <[email protected]>,
> [email protected] says...
> > 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
>

In article <[email protected]>,
[email protected] says...
>
> > 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!
>
{shrug} If you say so.

--
Regards,

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

In article <[email protected]>,
[email protected] says...
> 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" wrote:
>
> > In article <[email protected]>,
> > [email protected] says...
> > > 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
> >
>