Secondly, click on the Add Chart Element drop-down on the Chart Layouts ribbon group.Initially, move to the Chart Design tab.Now, we’ll do some formatting on the chart. In the end, check the box before Smoothed line.Īt this moment, the line of the chart gets smoothed and looks like that.After that, select Line like in the image below.Here, click on the Fill & Line icon (Spilling Color Can).Instantly, the Format Data Series task pane opens on the right side of the display. Then, select Format Data Series from the menu.Now, right-click anywhere on the series on the chart to get the context menu.Immediately, a Line Chart appears on the worksheet. Following this, select 2-D Line from the available options.Then, click on the Insert Line or Area Chart drop-down on the Charts group.First of all, select cells in the B4:D14 range.In our first method, we’ll use the Smoothed line option in the chart to smooth data in Excel. If any methods won’t work in your version, then leave us a comment. Here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience. Now, we’ll show how we can smooth the data in Excel using the dataset above. This dataset includes Period, Month, and Demand in columns B, C, and D consecutively. Conclusion Smooth Data in Excel: 6 Methodsįor ease of understanding, we’re using a Product Demand chart for a certain product.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |