Outstanding Excel Line Chart Smooth Curve
To smooth the middle of the curve as you drew it I would suggest that you break up your data into 3 series.
Excel line chart smooth curve. Click Line to make sure the line options are visible. 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. Select the chart and right click anywhere within the chart.
I believe that straight angles give. Choose the Format Data Series Choose the Fill and Line option pouring bucket. See above screen shot.
Excel displays the Format Data Series task pane at the right side of the screen. To edit this to a curved line right-click the data series and then select the Format Data Series button from the pop-up menu. The ends of the trendline probably will not connect to the first and last series exactly as you drew it.
Use the NA function in the blank cell of the charts data range. Algorithm excel charts smoothing vba. Lets customize this line chart.
Follow edited Jul 9 18 at 1841. Alternatively you might try a moving average. Right click on the jagged line.
You can follow the question or vote as helpful but you cannot reply to. Click Select Data and then click Hidden and Empty Cells. It is easy to create a line graph using either program.