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

Stop Responding to Threats.
Prevent Them.

Want to get monthly tips & tricks?

Subscribe to our newsletter to get cybersecurity tips & tricks and stay up to date with the constantly evolving world of cybersecurity.

Related Articles