connect two broken points of a graph

[Khoshravan]

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.

 

[Khoshravan]

forget to add that my chart type is not linear. it is scatter. would it be
possible?

 

[Tushar Mehta]

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

 

[Khoshravan]

Thanks
I didn't know that there is a tab for chart commands in Tools/option. They
are set apart from chart menu command