Excel.Tips.Net: Smoothing Out Data Series

By Allen Wyatt for Excel.Tips.Net

Smoothing Out Data Series

When you create line charts in Excel, the lines drawn between data points tend to be very straight. (This makes sense; the lines are meant to connect the points.) You can give your graphs a more professional look by simply smoothing out the curves Excel uses at each data point.

Follow these steps:

1. In your chart, right-click on the data series that you want to smooth. Excel displays a Context menu.

2. Choose Format Data Series from the Context menu. Excel displays the Format Data Series dialog box.

Steps Continued Here

379 total views, 1 views today

(Visited 208 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.