View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Khoshravan
 
Posts: n/a
Default 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