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?
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.
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. .
Asked: 2019-02-03 00:39:07 +0100
Seen: 127 times
Last updated: Feb 03 '19
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
