| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| missing data points causes my line graph not to connect | Charts and Charting in Excel | |||
| Connecting Points In An XY-Scatter Plot Graph | Charts and Charting in Excel | |||
| joining data points on graph | Charts and Charting in Excel | |||
| I can't get the lines to connect on my line graph | Charts and Charting in Excel | |||
| graph does not show all plotted points | Charts and Charting in Excel | |||
Hybrid Mode
