# [SOLVED] - Attempting to make a graph in LibreOfficeCalc using an exponential Y-axis but i keep getting it wrong

#### HTC

So here's the original linear graph:

And here's the modification of the Y-axis to logarithmic:

I want each horizontal line to represent double the previous one, instead of ten times as much, so how do i do it?

The file from which i made the chart is attached but, so far, the totals column hasn't been filled yet: had to compress it into Zip format because ODS extension isn't allowed in attached files.

#### Attachments

• 13.2 KB Views: 22

#### FordGT90Concept

##### "I go fast!1!11!1!"
Not really sure what you're asking for but you can use sheet.columnrow to address data from a different sheet. e.g. make a new sheet then do =Sheet1.B2 to copy the original value. If you want to do an additive thing: =Sheet1.B2+Sheet1.B3 then propagate that down the entire column. Get the raw data you want and graph away.

Placing a \$ makes it absolute so it won't increment when dragged.

The first graph already looks like what you want, no?

Last edited:

you have to play with minor/major interval values

#### HTC

Not really sure what you're asking for but you can use sheet.columnrow to address data from a different sheet. e.g. make a new sheet then do =Sheet1.B2 to copy the original value. If you want to do an adative thing: =Sheet1.B2+Sheet1.B3 then propagate that down the entire column. Get the raw data you want and graph away.

Placing a \$ makes it absolute so it won't increment when dragged.

The first graph already looks like what you want, no?
Nope. In the 1st graph, each horizontal line is 200 higher than the previous, which is a linear increase.

Instead of the logarithmic scale of the 2nd graph:

- 10000
- 1000
- 100
- 10
- 1

In the Y axis, i want something like:

- 3200
- 1600
- 800
- 400
- 200
- 100
- 50
- 25

you have to play with minor/major interval values
Tried to mess with those but, so far, without success.

i dont think you'll be able to represent geometric progression with only start value and interval while not having info on how major/minor interval impact scaling intervals of the graph

#### HTC

i dont think you'll be able to represent geometric progression with only start value and interval while not having info on how major/minor interval impact scaling intervals of the graph
This is supposed to be an attempt @ representing the progression of infected COVID-19 cases in Portugal. I've since added the accumulated totals.

Thus far, we have over 24K infected cases so the graph should go @ least as high as 25600, as per the scale i suggested in my previous reply. This will increase but, since the next value is 51200, there's a long way to go to reach it, hopefully.

My plan was to do this for several countries and then compare the shape of the lines from the charts.

Last edited:

#### Vya Domus

From what I can understand what you want basically is instead of having a logarithmic scale in base 10, you want it in base 2. So each equally spaced tick on the vertical axis represents an increase in 2x instead of 10x. Right ? I don't think there is any straight forward way of changing it unfortunately, I could only find this :

#### FordGT90Concept

##### "I go fast!1!11!1!"
Seems to work. Select graph -> Format -> Axis -> Y-Axis then make the tabs match below.

Last edited:

#### mtcn77

From what I can understand what you want basically is instead of having a logarithmic scale in base 10, you want it in base 2. So each equally spaced tick on the vertical axis represents an increase in 2x instead of 10x. Right ? I don't think there is any straight forward way of changing it unfortunately, I could only find this :

I agree, there is no an option to select log base - glad to be mistaken.

But how is that any different than what it is now except in labeling? If the inputs are the same then nothing changes other than the labels...which you could hide and replace (Format -> Axis -> Y-Axis -> Label tab -> untick box).
It shows power law, base 2 that is.

Last edited:

#### HTC

From what I can understand what you want basically is instead of having a logarithmic scale in base 10, you want it in base 2. So each equally spaced tick on the vertical axis represents an increase in 2x instead of 10x. Right ? I don't think there is any straight forward way of changing it unfortunately, I could only find this :

Correct: that's what i want, then do it for a few countries and then compare the shape of the lines of the various graphs.

But how is that any different than what it is now except in labeling? If the inputs are the same then nothing changes other than the labels...which you could hide and replace (Format -> Axis -> Y-Axis -> Label tab -> untick box).
The shape of the lines changes.

#### mtcn77

Portugese! Eat yoghurt! And reach out to these guys who made the study. They are Greek and the study is only 4 years old.
I have an intuition that 'this' follows the nations who are most lactose intolerant. Sorry, if you find that disturbingly simple, much of null hypotheses are.

you can change log base in excel.
didnt seen such option in libreoffice.

and i have to update my installation too ^^

#### FordGT90Concept

##### "I go fast!1!11!1!"
I edited my post trying what Vya Domus linked, seems to work as intended.

#### Vya Domus

Correct: that's what i want, then do it for a few countries and then compare the shape of the lines of the various graphs.

The shape of the lines changes.
You could just take the values for the y axis and take the log 2 of them and use those for the plotting with no logarithmic scale.

#### HTC

I edited my post trying what Vya Domus linked, seems to work as intended.
I must be doing something wrong:

The current file with the accumulated totals is in attach, zipped again. It's only up to yesterday's results, so far.

You could just take the values for the y axis and take the log 2 of them and use those for the plotting with no logarithmic scale.
Dunno how to do that

you can change log base in excel.
didnt seen such option in libreoffice.
View attachment 153189
and i have to update my installation too ^^
No longer use Windows, so that's not an option.

#### Attachments

• 15.6 KB Views: 17

#### mtcn77

I must be doing something wrong:

View attachment 153190

The current file with the accumulated totals is in attach, zipped again. It's only up to yesterday's results, so far.

Dunno how to do that

No longer use Windows, so that's not an option.
Have you tried to select the minimum '1' and minor interval '2'?

#### FordGT90Concept

##### "I go fast!1!11!1!"
I must be doing something wrong:

View attachment 153190

The current file with the accumulated totals is in attach, zipped again. It's only up to yesterday's results, so far.

Dunno how to do that

No longer use Windows, so that's not an option.
It's really important to set Major Interval to 0.30103 and Minor Interval Count to 10.

#### Attachments

• 22.5 KB Views: 19
HTC

#### HTC

Have you tried to select the minimum '1' and minor interval '2'?
Figured out my mistake: forgot to select "logarithmic scale" ... DUH ...

This is what i was searching for:

Now, to polish things up, i just need to figure out the formula to have the accumulated totals more easily ... because i added the totals one by one ..., then change the names of the columns in the charts to "daily" and "accumulated", respectively. None of which i know how to do ...

Then repeat this but for other countries, and finally compare the shape of the lines in the graphs.

#### mtcn77

Figured out my mistake: forgot to select "logarithmic scale" ... DUH ...

This is what i was searching for:

View attachment 153199

Now, to polish things up, i just need to figure out the formula to have the accumulated totals more easily ... because i added the totals one by one ..., then change the names of the columns in the charts to "daily" and "accumulated", respectively. None of which i know how to do ...

Then repeat this but for other countries, and finally compare the shape of the lines in the graphs.
You're doing great. Don't let it overbear on you.

#### FordGT90Concept

##### "I go fast!1!11!1!"
Might I suggest the Column and Line graph?

#### HTC

Might I suggest the Column and Line graph?
I posted the file with the data: you can see how i did it.

It would be much easier if, instead of inputting two sets of data (the daily totals + the accumulated totals), i could do it with just the daily totals and have spreadsheet calculate the rest for me.

I also added the dates one by one as well.

both solutions (with log2 of the data and with log scale of the axis)
i think log scales will fit your needs better

edit:
I posted the file with the data: you can see how i did it.

It would be much easier if, instead of inputting two sets of data (the daily totals + the accumulated totals), i could do it with just the daily totals and have spreadsheet calculate the rest for me.

I also added the dates one by one as well.
in the c3 cell add " =C2+B3 "
then move the cursor over the + at the bottom right of the cell hold Lclick and drag down along the column until you reach last row with data (or a bit more if you plan to add more data later)

#### Attachments

• 25.6 KB Views: 13
Last edited:
HTC

#### mtcn77

would be much easier if, instead of inputting two sets of data (the daily totals + the accumulated totals), i could do it with just the daily totals and have spreadsheet calculate the rest for me.
You could formulate if you set a different column adding the two upper columns into the field down a rank. So you have daily change(incidence)=x1, former total(prevalence, old)=x2, daily total=(prevalence, new). X3 is then x2 in the next rank. I haven't thought of it any other way, outside of iterations.

You set C3 to "=B3+C2" and C4 to "=C3" once rule is trained by you entering it(have to press enter for the whole C column), further modifications to field B(you just type in today's incidence) ought to train the next columns.

Last edited:
HTC

#### HTC

You could formulate if you set a different column adding the two upper columns into the field down a rank. So you have daily change(incidence)=x1, former total(prevalence, old)=x2, daily total=(prevalence, new). X3 is then x2 in the next rank. I haven't thought of it any other way, outside of iterations.

You set C3 to "=B3+C2" and C4 to "=C3" once rule is trained by you entering it(have to press enter for the whole C column), further modifications to field B(you just type in today's incidence) ought to train the next columns.
But C4's value should be "=C3+B4" and not only "=C3", no?