Click Select Data and then click Hidden and Empty Cells. Select and highlight the range A1F2 and then click Insert Line or Area Chart Line. On the Format Data Series pane go to Fill Line tab Line section and select No line. I try to get VBA code of doing it by writing macros but all I have got is expected ActiveChartSeriesCollection1Smooth True. Excel variant of doing it is pretty good but I have no suggestion of what algorithm used. For Width increase to 2 pt Logic. I have had all series 13 in total on the chart and. What I have done so far is created two new series of data which is the calculated lower bound and upper bound and then plotted them on the graph. In your chart right-click on the data series that you want to smooth. In this example we want to create a curved line graph from this data on cookie sales.

Contrast the smoothed line chart to this standard line chart. Excel displays a Context menu. Click on the name of the data series that represents the smoothed line edit the cell range of the series to reflect the column that holds the particular smoothing technique and click OK to close the editing dialog boxes. Ad Get More Results from Your Graphs for Less Effort. Select and highlight the range A1F2 and then click Insert Line or Area Chart Line. Now I want to find out the values of Y for this curve that excel has fit as a smooth line for smaller intervals of X x-025-023-02-018. I plot them on a smooth line chart and it looks good. In this case smooth the line to make the overall trend more apparent and take the focus away from the point to point variation. For certain charts the most important information to be communicated is the overall trend of the line weve drawn. You now easily see that sales decreased from July to August 2009.

I was challenged as to the validity of the smoothing and was asked to identify the algorithm used by Excel. Just do the following steps. In your graph double-click the target line. And if you wish to make your current line chart smoother. For certain charts the most important information to be communicated is the overall trend of the line weve drawn. Choose Format Data Series from the Context menu. Do we have an expert in the group who could show how Excel smoothes lines in the graphs. In this example we want to create a curved line graph from this data on cookie sales. Excel variant of doing it is pretty good but I have no suggestion of what algorithm used. Excel displays a Context menu.

For certain charts the most important information to be communicated is the overall trend of the line weve drawn. In this example we want to create a curved line graph from this data on cookie sales. In your chart right-click on the data series that you want to smooth. Just do the following steps. I have a pivot chart obviously connected to a pivot table and am using a slicer to change the content. Choose the Format Data Series Choose the Fill and Line option pouring bucket. Well walk you through the process step by step to convert your graph. Ad Get More Results from Your Graphs for Less Effort. You now easily see that sales decreased from July to August 2009. In this case smooth the line to make the overall trend more apparent and take the focus away from the point to point variation.

What I am trying to do is shade the area between the lowest and highest values on the chart. I have a pivot chart obviously connected to a pivot table and am using a slicer to change the content. You can easily change this to a curved graph with nice smooth lines for a more polished look. On the Format Data Series pane go to Fill Line tab Line section and select No line. What I have done so far is created two new series of data which is the calculated lower bound and upper bound and then plotted them on the graph. Excel variant of doing it is pretty good but I have no suggestion of what algorithm used. A sample worksheet would help. Well walk you through the process step by step to convert your graph. Now I want to find out the values of Y for this curve that excel has fit as a smooth line for smaller intervals of X x-025-023-02-018. So as shown below to make a smooth line chart in MS Excel you would.