Thread
:
connect two broken points of a graph
View Single Post
#
4
Posted to microsoft.public.excel.charting
Khoshravan
Posts: n/a
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
Reply With Quote