| View previous topic :: View next topic |
| Author |
Message |
vomus
General User
Joined: 21 Sep 2006
Posts: 5
|
 Posted: Thu Sep 21, 2006 11:11 am Post subject: Trendlines in histograms |
 |
|
Hi!
I am trying to put a trendline on top of a histogram but it seems that a trendline can only be added to an xy-plot. All examples about trends I have seen so far talk about an xy-plot, not histograms.
Can anyone give a hint? If there is no way to do it directly, may be there is a workaround?
Thanks in advance,
Sergei |
|
| Back to top |
|
 |
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Thu Sep 21, 2006 12:07 pm Post subject: |
|
|
It isn't ideal but....
Use the SLOPE and INTERCEPT functions to define the trendline, and use the combined bar-graph and line chart.
I haven't worked it all out yet though.... |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Thu Sep 21, 2006 4:13 pm Post subject: Re: Trendlines in histograms |
|
|
| vomus wrote: | Hi!
I am trying to put a trendline on top of a histogram but it seems that a trendline can only be added to an xy-plot. All examples about trends I have seen so far talk about an xy-plot, not histograms.
Can anyone give a hint? If there is no way to do it directly, may be there is a workaround?
Thanks in advance,
Sergei |
How are you creating the histogram? Are you presorting into bins?
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
vomus
General User
Joined: 21 Sep 2006
Posts: 5
|
| Posted: Thu Sep 21, 2006 10:27 pm Post subject: Re: Trendlines in histograms |
|
|
| jrkrideau wrote: | | vomus wrote: | Hi!
I am trying to put a trendline on top of a histogram but it seems that a trendline can only be added to an xy-plot. All examples about trends I have seen so far talk about an xy-plot, not histograms.
Can anyone give a hint? If there is no way to do it directly, may be there is a workaround?
Thanks in advance,
Sergei |
How are you creating the histogram? Are you presorting into bins? |
No. It is not really a histogram but rather a bar chart. |
|
| Back to top |
|
|
vomus
General User
Joined: 21 Sep 2006
Posts: 5
|
| Posted: Thu Sep 21, 2006 11:24 pm Post subject: |
|
|
| RickRandom wrote: | It isn't ideal but....
Use the SLOPE and INTERCEPT functions to define the trendline, and use the combined bar-graph and line chart.
I haven't worked it all out yet though.... |
Yeah, I have figured that much. But there is one question related to this. How do I change a data range for this line if I want more points on the curve than on the bars?
Sergei |
|
| Back to top |
|
|
|
