Blog

Last week, while teaching a PowerPoint class, one student raised an excellent question?related to Excel. In fact, such a great question, that I thought I?d post both the question and the answer here for all to benefit.

“I have an Excel Line Chart with two lines. I?d like one line to appear as normal while the other line appears rounded. (See example below)

Essentially, within the chart, you need to select the ?data series? that you want have a ?smoothed effect.? This means, you need to select the chart by clicking it (In 2003, you?ll need to activate an embedded chart by double-clicking it). Then, you?ll want to select just the one line, or ?data series? that you want to smooth. Next, right-click the selected data series (or line) and choose ?Format Data Series? from the shortcut menu.In the Format Dialog Box, you?re looking for the line style options. This is where you?ll find line weight, line color, etc. Once you find these settings, look for a checkbox that says ?Smoothed Line.? That?s the box you want to check.You may also need to increase the weight of the line to acheive a more believable smoothed effect, like the one in the sample shown above.

Subscribe to the KeyStone OnDemand blog to be the first to learn about future Microsoft Excel training tips.