Thread: connect two broken points of a graph

How can I connect two broken points of a graph with a straight line? For
these points I don’t have “y” value but I want to make the graph continuous.
I have read before in internet but cant find know.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

forget to add that my chart type is not linear. it is scatter. would it be
possible?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Khoshravan" wrote:

> How can I connect two broken points of a graph with a straight line? For
> these points I don’t have “y” value but I want to make the graph continuous.
> I have read before in internet but cant find know.
> --
> Rasoul Khoshravan Azar
> Civil Engineer, Osaka, Japan

In article <A1D4B957-3501-47E7-AD54-FE2F06ABBDBA@microsoft.com>,=20
khoshravan@discussions.microsoft.com says...
> How can I connect two broken points of a graph with a straight line? For=
=20
> these points I don=E2=A4=3D3Ft have =E2=A4=BDy=E2=A4=9D value but I want =
to make the graph continuous.=20
> I have read before in internet but cant find know.
>=20
Select the chart, then Tools | Options... | Chart tab. In there set 'Plot=
=20
empty cells as' to 'Interpolated'.

--=20
Regards,

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

Thanks
I didn't know that there is a tab for chart commands in Tools/option. They
are set apart from chart menu command
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Tushar Mehta" wrote:

> In article <A1D4B957-3501-47E7-AD54-FE2F06ABBDBA@microsoft.com>,
> khoshravan@discussions.microsoft.com says...
> > How can I connect two broken points of a graph with a straight line? For
> > these points I donâ€=3Ft have “y” value but I want to make the graph continuous.
> > I have read before in internet but cant find know.
> >
> Select the chart, then Tools | Options... | Chart tab. In there set 'Plot
> empty cells as' to 'Interpolated'.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>