How to lock axis aspect ratio in chart?

Discuss the spreadsheet application
Post Reply
skrat
Posts: 19
Joined: Wed Dec 06, 2017 9:47 pm

How to lock axis aspect ratio in chart?

Post by skrat »

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
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to lock axis aspect ratio in chart?

Post by Zizi64 »

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; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
skrat
Posts: 19
Joined: Wed Dec 06, 2017 9:47 pm

Re: How to lock axis aspect ratio in chart?

Post by skrat »

Zizi64 wrote: Yes, it is possible. Accidentally.
:D
That's a bad intro.

I mean't graphically.
OpenOffice 4.1.4. Windows 10
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to lock axis aspect ratio in chart?

Post by Zizi64 »

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; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to lock axis aspect ratio in chart?

Post by Zizi64 »

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 83 times
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to lock axis aspect ratio in chart?

Post by Zizi64 »

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; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply