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

how to make graph y range 0-180-(-180)-0?

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


Joined: 27 Mar 2012
Posts: 4

PostPosted: Tue Mar 27, 2012 7:30 am    Post subject: how to make graph y range 0-180-(-180)-0? Reply with quote

I'm using the openoffice calc to create some graphs displaying the change in an angle, however it is desirable to never go higher then 180 degrees, so that instead of 0-360 it's 0 0 -> 180 -> (-180) -> 0

I would like the graph's y axies to go from 0 - 180 > -180 - 0, so in other words from 0 degrees, to 190 then switch into negative 180 and from negative 180 go back to 0. Is it possible to manipulate the graph to do this?
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: Wed Mar 28, 2012 8:34 am    Post subject: Re: how to make graph y range 0-180-(-180)-0? Reply with quote

Marbak wrote:
I'm using the openoffice calc to create some graphs displaying the change in an angle, however it is desirable to never go higher then 180 degrees, so that instead of 0-360 it's 0 0 -> 180 -> (-180) -> 0

I would like the graph's y axies to go from 0 - 180 > -180 - 0, so in other words from 0 degrees, to 190 then switch into negative 180 and from negative 180 go back to 0. Is it possible to manipulate the graph to do this?


Does your data not do this?

Also you can set the axis scales under format when you have the graph selected.

Is this any help?
_________________
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
Marbak
Newbie
Newbie


Joined: 27 Mar 2012
Posts: 4

PostPosted: Thu Mar 29, 2012 5:58 am    Post subject: Reply with quote

I'm probably explaining this a bit poorly, the data does of course give the appropriate values. And I know I can change the axis scales. if it was from -180 to 180 through 0 that would be easy. The problem is that it's not, the axis is from 0 to 180 directly to -180 to 0.

So that the axis would look like this:

deg
0----- |
-90---|
-180-|
180--|
90----|
0------|________________________Hz

What this really is, is 360 degrees, but it's not desirable to use values above 180 in this case. The actual degree value will be shifting between 160 - 200 degrees which is turned into 160 - (-160) degrees instead. If using a normal -180 - 180 scale this will give a wrong appearance as it goes between the two without ever passing the values between 160 and -160,
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 Mar 29, 2012 1:52 pm    Post subject: Reply with quote

I am lost. Any chance that you can point to a similar graph (any software inplementation) to show what you need.

At the moment I just don't see how you go from -180 to 180.

Quote:
The actual degree value will be shifting between 160 - 200 degrees which is turned into 160 - (-160) degrees instead.


just does not seem to make any sense. Are you sayting that all observed values have a constant of -160 subtracted from them?

I think we need a more detailed description of exactly what you are doing--subject matter reference as well-- to let us guess what is happening.

Sorry to be so little help.
_________________
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
Marbak
Newbie
Newbie


Joined: 27 Mar 2012
Posts: 4

PostPosted: Fri Mar 30, 2012 1:40 pm    Post subject: Reply with quote

The use is with electric alternating currents, they're displayed as waves. Measuring the input wave versus the output wave revealing the lag (not sure if lag would be the appropriate term, English isn't my native language) in the current. When right on top of each other it's 0 degrees. When the output is shifted slightly to one side of the input it will gain a positive lag of x degrees, the other way gives a negative x degrees.

If shifted to the point where the output is the opposite of the input it will be 180 degrees.
if shifted a whole 'round' making it 360 degrees it's 0 degrees. It's completely uninteresting if it's actually 360 degrees, 720 degrees or anything like that, it's just considered 0 degrees. just the difference between the two on one cycle that's of importance.

With this logic 180 degrees, is the same as -180. When watching a wave which will probably be the thousandth cycle or more of a current you can't see if it comes before or after as all you see are two continuous waves.

This also makes it so that 200 degrees may just as well be -160 degrees, 100 degrees just as well be -160 degrees. It's waves not circles or physical degrees. Because of this it's desired to only use -160 - 160 degrees, not 0 - 360. Therefore at a point it will go from -> 180 to -180 -> ( ... 178 > 179 > 180/-180 > -197 -198 ...)


With a capasitor or/and coil in a circuit it will add this lag depending on the frequency of the input, it's to display how the circuit's lag change depening on the frequency. This one shifts with x degrees around the area of 180 degrees. so for example 175-(-175) which could be said as 175-185 in which case it's more obvious that the line shouldn't run through the area between 175 to 0 to -175. But again, it is desirable to use negatives over values higher then 180.

Right now I have to 'cheat' using actual values of 0-360, then hide the scales on x axis with some solid text block or similar where I add the corresponding negative values of those above 180. Would like to not have to do that though
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Fri Mar 30, 2012 5:32 pm    Post subject: Reply with quote

You could add a dummy series then use its category labels to take the place of the normal 0 to 360 degree y axis labels.
http://www.mediafire.com/view/?td5ec31orvmu6v1
In the above attached doc (Dummy series for unusual y axis labels.ods) the chart has two data series.
The first is a plot of columns A and B.
The chart's y axis Scale has been altered from Automatic to Minimum = 0, Maximum = 360, and Major interval = 30 (to match the spacing of the values in column D). The y axis' labels have had their format changed from General (same as Source) to three semicolons (;;;). This format code renders the usual y axis labels invisible.
The second is a plot of columns C and D with column E included as the category values.
The second series' line is changed to invisible and its Markers have been removed. Also, the second series is set up to include its data labels and those labels are set to show only the Category with Placement equal to Left.
You should notice that the column E label values each have a trailing space character. This separates the new y axis labels from the tick marks for a better appearance.
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).


Last edited by ken johnson on Mon Sep 24, 2012 5:01 am; edited 1 time in total
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: Fri Mar 30, 2012 5:41 pm    Post subject: Reply with quote

[quote]English isn't my native language)
Quote:


I should be as fluent in another language!

Okay, I think I may be able to figure out what you need but my physics, etc, are from 40 years ago. Perhaps some more current member of the group can help?

It's late here and I'll have to think about this in the morning but at least I think I have slightly better idea of the problem.

_________________
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
Marbak
Newbie
Newbie


Joined: 27 Mar 2012
Posts: 4

PostPosted: Sat Mar 31, 2012 5:25 am    Post subject: Reply with quote

Thank you, that to be what I need.
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Sun Apr 01, 2012 9:26 pm    Post subject: Reply with quote

The original Y axis labels can also be hidden by right-clicking the y axis, choosing "Format axis..." from the popup menu then removing the tick from the "Show labels" check box on the "Labels" tabsheet of the "y Axis" dialogue.
I knew there had to be an easier way than using the ";;;" format code. It had slipped from my mind.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
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