Breathtaking Excel Make Line Chart Smooth

I need to find what is the value of y for this curve that excel has fit by scatter with smooth lines option for different intervals of X.

Excel make line chart smooth. In your chart right-click on the data series that you want to smooth. Only if you have numeric labels empty cell A1 before you create the line chart. Excel displays the Format Data Series task pane at the right side of the screen.

The line graph is inserted with straight lines corresponding to each data point. In this video Ill show you how to make a smooth line graph in Microsoft Excel. On the Chart tab click Interpolated and then click OK.

For certain charts the most important information to be communicated is the overall trend of the line weve drawn. Both Excel and Word have options for you to insert charts and graphs. You can follow the question or vote as helpful but you cannot reply to.

You could subdivide the data and determine where the smoothed data goes which is a bit of a chore. I plot them on a smooth line chart and it looks good. On the Insert tab in the Charts group click the Line symbol.

How to Make a Line Graph in Excel. Right click the series you need and select Format Data Series in the context menu. It is easy to create a line graph using either program.

The most effective visuals are often the simplestand line charts another name for the same graph are some of the easiest to understand. This thread is locked. Search Engine Optimization SEO Tips.