Ask Your Question

create trend line without selecting data series

asked 2019-02-03 00:39:07 +0100

catbill gravatar image

updated 2020-07-27 11:14:41 +0100

Alex Kemp gravatar image

When I try to create a trend line without first selecting a data series, the Trend Line option is grayed out. Does Calc require that we select one or more data series before this option is available? If it does not, how can I make it available?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-03 03:38:10 +0100

ve3oat gravatar image

It is a matter of definition. A trend line requires some data for which to establish a trend. It is the trend of the data that is being graphed; therefore, you must select a data series for the line. I know of no other way.

If you wish to show some arbitrary line on your chart, say for a threshold or a limit, you could create a data series with appropriate values and select it as the required data series. I have done this, using values for only the end-points, for some of my own charts.

edit flag offensive delete link more


Thank you. I should have been clearer. I asked because the user guide says that if no data series is selected, then a trend line will be created for all of the data.

So, I am checking to see if the user guide is correct. It appears that it is not.

catbill gravatar imagecatbill ( 2019-02-03 16:27:46 +0100 )edit

Interesting. I was not aware of the statement in the user guide. Playing around a bit (v5.4), I could not find a way to select more than one series of data in order to create a trend line. It seems that the ability to create a trend line for all of the data has been lost in recent versions, if it ever really existed. It should be reported as a bug.

You didn't say which version you are using. Perhaps someone with more skill than mine can suggest a solution to you. .

ve3oat gravatar imageve3oat ( 2019-02-04 21:51:43 +0100 )edit

Yes, both the Calc user guide and the online help say this. If it is not true, I will make sure that the information in both places is corrected.

Thank you for looking into this.

catbill gravatar imagecatbill ( 2019-02-05 00:32:35 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-03 00:39:07 +0100

Seen: 230 times

Last updated: Feb 03 '19