Swap X and Y axis in a spread sheet file

Hi,

I am using Libreoffice 7.3.0.1 x64.

I have created a spread sheet file that contains for a 5 kVA UPS unit run time data and at what load the data has been measured.

When I create a chart then the load is always on the X axis and the run time in minutes is on the Y axis. However I want on the X axis the run time and on the Y axis the load.

I have been trying to do this but was unable to achieve my goal.

I appreciate if I can get step-by-step instructions on how to swap the axis around.

Attached is the spread sheet file.

Thank you!

Regards,

Gaismair
5kva_run_times.ods (13.8 KB)

What didn’t I understand?

The way I read the data, the load coilumn doesn’t give values of a continuous variable, but classes (“up to” I would assume) for a distribution.
E.g: “The internal battery provided up to 25% of the total load for 27 minutes.”
(Next higher class then >25 % but <=50%).
Thus the values given in minutes also don’t describe moments of a flowing time, but are added durations. I neither can see these values as classes of a distribution (or members of any obviously defined one), nor as points in contiouous time.
My conclusions:
A “line” diagram is the wrong means for what you have. A column diagram should be appropriate.
A question like “For what maximum load (of a small number of classes) did this battery pack XY run up to 50 minutes?” should not be assumed sensible.

What didn’t I understand?

5kva_run_times bearb.ods (16,7 KB)

Is this how you imagined it?


See also:
Rotating Tables in Calc

1 Like

Thank you, @Hrbrgr.

1 Like

Yes, this way it makes sense.
However:

  • The line type still is misleading.
  • The axes did not change roles. Time (accumulated duration) is still assigned to the verttical axis.
  • The load ranges are now used as column labels and distinguish the series.

See also this attached sheet: 5kva_run_timesAdditionalSuggestions.ods (16.9 KB)

Finally: The wiki page we were hinted to mixes up the terms “rotate”, “transpose”, “swap” in a very bad way. The detailed text is even worse than the title.
This comment wasn’t sufficiently considered. Sorry!
(No. I will not start to edit pages of that wikli.)

Thank you, Lupp.

Sorry for the late reply.

Some explanations to your comments in the provided Calc file -

The horizontal axis should actually show the run time in minutes. EBM is an abbreviation for Extended Battery Module, that is a chassis in the size of the UPS containing one or more batteries.

The vertical axis should actually show the load in % of the UPS capacity. If the UPS has a capacity of 4500 W then the measurements were taken with the following load:

25 % = 1125 W
50 % = 2250 W
75 % = 3375 W
100 % = 4500 W

These are four measurement points. Unfortunately no more detailed measurements are made during test, i.e. nothing at 0 %, 5 % etc. of the UPS capacity.

As an example -

The run time of the UPS with two additional EBMs (+2 EBM) at a load of 75 % (3375 W) has been measured to be 53 minutes. This means that after 53 minutes run time the UPS has shut down and turned off. The run time requires that the utility power to the UPS is cut.

HTH.

Yes, I also used UPSes many years ago.

I understood this as something you wanted to be done in the solution. At least it wasn’t the case in the diagram contained in your attachment:
But it also isn’t found in the solution you accepted.
Both these diagrams don’t use the horizontal axis for any variable in the sense engineering is using the term generally, but for classes the respective parts of the total runtime of the system are accumulated for. In the original we need to understand the classes as intervals of the relative load. These may be disjunct:
0%<= relLoad <=25%; 25% <relLoad <=50%; 50% <relLoad <=75%; 75% <relLoad <=100%
or inclusive:
0%<= relLoad<=25%; 0%<= relLoad <= 50%; 0%<= relLoad <= 75%; 0%<= relLoad<=100%.
Since the given series in your example all are strictly descending, the second alternative can’t be excluded, but the first interpretation also is consistent. You must tell which one of the alternatives is fact.
Anyway: Using a line diagram to show accumulated time over classes should be judged misleading. Science and engineering use line diagrams to visualize a relation between (roughly) continuous variables. Looking at a line diagram should therefore be suspected to trigger an attempt to read it this way. To avoid a misunderstanding I would suggest to use a column diagram for a visualization of what you actually have.
This would also make intuitively clear that an exchange of the axes doesn’t make sense. You can use, hoiwever, the EBM names as classes in place of the load ranges. This is what @Hrbrgr did. The values shown in the diagram still are accumulated durations.
You can’t use this kind of “time” as a variable, nor can I see any sense in making classes of them.

Many thanks for your explanations, Lupp.

I now understand the situation and I consider this issue as resolved.