OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Two Currencies on one graph

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
gdi2k
Newbie
Newbie


Joined: 29 Dec 2004
Posts: 3

PostPosted: Wed Nov 11, 2009 7:53 pm    Post subject: Two Currencies on one graph Reply with quote

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
View user's profile Send private message
remo00
OOo Enthusiast
OOo Enthusiast


Joined: 21 Dec 2006
Posts: 117

PostPosted: Thu Nov 12, 2009 5:34 am    Post subject: Reply with quote

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
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Thu Nov 12, 2009 5:36 am    Post subject: Re: Two Currencies on one graph Reply with quote

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
View user's profile Send private message
gdi2k
Newbie
Newbie


Joined: 29 Dec 2004
Posts: 3

PostPosted: Wed Nov 18, 2009 6:42 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group