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 dont 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

connect two broken points of a graph
 

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 dont 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

connect two broken points of a graph
 

In article ,
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

connect two broken points of a graph
 

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 ,
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