[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
Marbak
Newbie

Joined: 27 Mar 2012
Posts: 4

 Posted: Tue Mar 27, 2012 7:30 am    Post subject: how to make graph y range 0-180-(-180)-0? 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?
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6733

Posted: Wed Mar 28, 2012 8:34 am    Post subject: Re: how to make graph y range 0-180-(-180)-0?

 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
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Marbak
Newbie

Joined: 27 Mar 2012
Posts: 4

 Posted: Thu Mar 29, 2012 5:58 am    Post subject: 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,
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6733

Posted: Thu Mar 29, 2012 1:52 pm    Post subject:

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
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Marbak
Newbie

Joined: 27 Mar 2012
Posts: 4

 Posted: Fri Mar 30, 2012 1:40 pm    Post subject: 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
ken johnson
Super User

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

 Posted: Fri Mar 30, 2012 5:32 pm    Post subject: 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
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6733

Posted: Fri Mar 30, 2012 5:41 pm    Post subject:

[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
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Marbak
Newbie

Joined: 27 Mar 2012
Posts: 4

 Posted: Sat Mar 31, 2012 5:25 am    Post subject: Thank you, that to be what I need.
ken johnson
Super User

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

 Posted: Sun Apr 01, 2012 9:26 pm    Post subject: 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).
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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