Questions tagged [trendlines]
The trendlines tag has no usage guidance.
8
questions with no upvoted or accepted answers
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...