Ask Your Question

two curves in one graph with different line types: smooth and stepped

asked 2019-10-08 13:09:29 +0100 gravatar image

updated 2020-07-22 13:27:11 +0100

Alex Kemp gravatar image

I need to have two different type of lines in one graph. I have been searching in the "help" text document and in the internet in forums or discussions here but could not find the answer: is it possible to do or this program can not provide this option?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-10-08 16:03:56 +0100

ve3oat gravatar image

updated 2019-10-08 16:20:52 +0100

Yes. Double-click on the chart to put it in Edit mode. Left-click on one of the lines to select it. Right-click on it to get the dialog box. Choose the "Format data series" option. Choose the type of line that you prefer. Do the same for your other line. When finished, double-click on an empty cell somewhere else in your spreadsheet to take the chart out of Edit mode.

There are many options for editing the appearance of charts. Experimentation is encouraged.

If this answer helped you, please accept it by clicking the check mark ✔ to the left. That will help other people with the same question.

edit flag offensive delete link more


Hello, thank you for the reply. But when I do like you described I have only option to change STYLE of the line in "Data series/Line" window. So I can do the line "Continuous" or "Dashed". But I need to have different TYPE of line! So I need one line "Stepped" or "Straight" and another line "Smooth" gravatar ( 2019-10-10 11:10:25 +0100 )edit

OK, do you mean a line or curve that is fitted to the data? If so, LibreOffice calls them Trend lines and there are six choices : linear, power, polynomial, logarithmic, exponential, and moving average. Do as above but instead of selecting Format Data Series, select Insert Trend Line, in the dialog box.

By "stepped line", do you mean a line that only connects successive data points? That is chosen near the beginning of the charting process.

ve3oat gravatar imageve3oat ( 2019-10-10 15:55:21 +0100 )edit

thank you very much, yes it works with the 'moving average' mode. but it's not straight forward way, because plus to all this above mentioned actions I also need to rid off the initial curved type line. So i did it like change the colour of the initial line to white or put wide too zero and chose the option "without symbols" on the curve. But it's boring..I thought there was another way... gravatar ( 2019-10-23 04:16:38 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-08 13:09:29 +0100

Seen: 288 times

Last updated: Oct 08 '19