Ask Your Question

Smoothing in Column and Line chart [closed]

asked 2014-12-11 11:01:36 +0200

deniscampbell gravatar image

Is there any way to smooth the line in a combined column and line chart?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-07 01:24:24.707655

2 Answers

Sort by » oldest newest most voted

answered 2014-12-11 16:07:08 +0200

w_whalley gravatar image

You can insert a trend line, then, if desired, make the original line invisible. The trend line can be linear, logarithmic, exponential, power, polynomial or moving average. Choose the one that works best for you.

To insert a trend line, double-click the chart and click on the line so it is selected then right-click to bring up a dialog. Choose Insert Trend line, then make your selections. To make the original line invisible or change how it is displayed, select the line, right-click and choose Format Data Series in the pop-up dialog. Set the line style, color, width, etc.

When I made the line invisible I had a hard time finding it to select it again (so be cautious).

edit flag offensive delete link more

answered 2014-12-11 14:04:36 +0200

ROSt52 gravatar image

I made a test using LibO According to my results it is not possible to have smoothed line curve in combination with a column chart.

May I propose you file an enhancement request here:

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-12-11 11:01:36 +0200

Seen: 1,248 times

Last updated: Dec 11 '14