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

About Excel Tips

The tips and ideas from ExcelRibbon.Tips.Net are designed specifically for users of Excel starting with Excel 2007. You'll find just about everything you need to become productive with the program right away. (If you need help with other versions of Excel, visit the ExcelTips site.)

•