How to lock axis aspect ratio in chart?

Discuss the spreadsheet application

How to lock axis aspect ratio in chart?

Postby skrat » Thu Dec 07, 2017 1:54 pm

As you can see from the attached snapshot, 1 unit on x axis is a lot smaller than 1 unit on y axis.

Captgfhdfgjure.PNG


Is it possible to make than 1:1? Meaning the units on both axes have the same size? That would really help me a lot
OpenOffice 4.1.4. Windows 10
skrat
 
Posts: 19
Joined: Wed Dec 06, 2017 9:47 pm

Re: How to lock axis aspect ratio in chart?

Postby Zizi64 » Thu Dec 07, 2017 2:25 pm

Is it possible to make than 1:1? Meaning the units on both axes have the same size?


Yes, it is possible. Accidentally.
:D

Do you meant: grahically or numerically same size?
It is depend on the size and the ratio of the chart frame, and the graph area of the chart. You can play with it, by manual adjusting of the sizes
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.3 and AOO4.1.4
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6083
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to lock axis aspect ratio in chart?

Postby skrat » Thu Dec 07, 2017 2:27 pm

Zizi64 wrote:Yes, it is possible. Accidentally.
:D

That's a bad intro.

I mean't graphically.
OpenOffice 4.1.4. Windows 10
skrat
 
Posts: 19
Joined: Wed Dec 06, 2017 9:47 pm

Re: How to lock axis aspect ratio in chart?

Postby Zizi64 » Thu Dec 07, 2017 4:35 pm

I mean't graphically.


I think, you can not adjust the scale of the axes exactly in pixels or in mm/inches. You can adjust the size "by eyes" only.
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.3 and AOO4.1.4
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6083
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to lock axis aspect ratio in chart?

Postby Zizi64 » Thu Dec 07, 2017 4:59 pm

Just a tip:

Try to draw two helper measure line in the Draw application (a horizontal one, and a vertical one), scaled to the desired axis size and numeric scale.
and then copy them into the Calc.

Then you can adjust the chart frame or the graph area sizes manually to the measure lines by a simple visual/manual method.

Finally delete the measure lines.
Attachments
Scale chart graphically.ods
(15.57 KiB) Downloaded 9 times
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.3 and AOO4.1.4
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6083
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to lock axis aspect ratio in chart?

Postby Zizi64 » Thu Dec 07, 2017 6:19 pm

Ahhh, sorry, I was wrong...

You CAN adjust the size of the graph area of the charts (= the axes size) numerically. You need choose same ratio for the axes max. values and the Graph area vertical/horizontal size.

ScaleGraph.png
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.3 and AOO4.1.4
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6083
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 42 guests