| View previous topic :: View next topic |
| Author |
Message |
gdi2k
Newbie
Joined: 29 Dec 2004
Posts: 3
|
 Posted: Wed Nov 11, 2009 7:53 pm Post subject: Two Currencies on one graph |
 |
|
Greetings,
I have a graph plotting temperatures over time that I will be presenting to two groups of people, one more familiar with Celsius and one more familiar with Fahrenheit units.
I am using Celsius as my primary Y-axis, but would like to add Fahrenheit to the secondary Y-Axis. Is this possible?
Thanks! |
|
| Back to top |
|
 |
remo00
OOo Enthusiast
Joined: 21 Dec 2006
Posts: 117
|
| Posted: Thu Nov 12, 2009 5:34 am Post subject: |
|
|
Yes it is possible.
display second Y axis
put as min and max and interval the value in °F corresponding to the min and max in °C
careful to choose the min value so that the value in °F is significant
so if your Y1 axis with °C has Min=0, Max=140 Interval=20
your Y2 axis with °F should have Min=32, Max=284 Interval=36 |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Thu Nov 12, 2009 5:36 am Post subject: Re: Two Currencies on one graph |
|
|
| gdi2k wrote: | Greetings,
I have a graph plotting temperatures over time that I will be presenting to two groups of people, one more familiar with Celsius and one more familiar with Fahrenheit units.
I am using Celsius as my primary Y-axis, but would like to add Fahrenheit to the secondary Y-Axis. Is this possible?
Thanks! |
Yes, F is simply a linear funtion of C so if you calculate the min and max values you should be okay.
Create the chart, pick Insert > Axes > Seconday Y axis and adjust the scale.
Personally, if I had the option I'd do two graphs or sets of graphs and present the relevant ones to the different audiences but I realise that this is not always possible.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
gdi2k
Newbie
Joined: 29 Dec 2004
Posts: 3
|
| Posted: Wed Nov 18, 2009 6:42 am Post subject: |
|
|
Excellent, thanks for the responses, works as described.
Sorry about the late reply, didn't get notified when you responded for some reason... |
|
| Back to top |
|
|
|
