Questions tagged [trendlines]

The tag has no usage guidance.

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
1 answer
1k views

Any way to make interactive graphs in LibreOffice like Google Doc's Trend chart?

Google Docs has a nice trend viewer that can be created just like any other chart: Is there any way to get an interactive graphic like this in OpenOffice? Manually adjusting the axes is really ...
endolith's user avatar
  • 7,627
1 vote
1 answer
54 views

Linear Trendline does show up wrong in x,y chart in Excel

I have a simple set of GPS data for posts of a solar farm and want to add a trendline in a x,y chart to visualize the tolerance to the alignment of said posts. It works with the height of the posts ...
Steven Fechner's user avatar
1 vote
0 answers
1k views

Highlight/Select specific data points on excel chart to draw a trend line

I hope I can get some help with the problem that I'm trying to solve. I want to be able to chart some stock data using excel. I have that part done. I have 3 columns (date, high, low, close). I am ...
user3399732's user avatar
1 vote
1 answer
627 views

Excel - Reuse a trend line to apply to other data

I've obtained a trend line from a particular set of data. What I'd like to do now is to reuse this trend line to predict values from a given pair (x,y) of coordinates. To put it another way, I have ...
milko's user avatar
  • 11
0 votes
1 answer
296 views

Graph with trend line and up-and-down arrows showing variation

I want create a graph that shows the trend of population (number of residents in the city) across the years. Ideally I would show the trend with a line, but also columns should be fine. The hard part ...
Michele Cordini's user avatar
0 votes
0 answers
31 views

TREND function in Gnumeric only outputs one cell

Hello I have a col of x values, and col of y values, and next to them an empty column, i am attempting to select the empty column of similar length as x and y, and enter the TREND function, but i only ...
Kiers's user avatar
  • 101
0 votes
0 answers
1k views

How to make best fit line that is weighted according to precision of each data point

I have got a set of experimental data calledxdata and ydata that I want to approximate with a trend line. Traditionally, Libreoffice Calc calculates the optimal trend line using a method which gives ...
loic17's user avatar
  • 175
0 votes
0 answers
1k views

Trendline not printing

I have many pages with similar graphs and data tables to print. And there is one page that does not print the trendline in the graph. I reloaded the file and tried printing it which worked out, then i ...
Madmenyo's user avatar
  • 890