In article <638625CB-DC4C-42D6-8D26-1060E0A18560@microsoft.com>,
monir@discussions.microsoft.com 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 <638625CB-DC4C-42D6-8D26-1060E0A18560@microsoft.com>,
monir@discussions.microsoft.com 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 <7365A2E8-BE5E-4217-8DEA-FD6912B5ACD1@microsoft.com>,
> > monir@discussions.microsoft.com 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
> >
>