Single Series in Scatter Plot Sourcing from Several Table Columns

[GPWR]

Greetings.

I have three columns with data which are really a continuity of each other. The first column has the data of population censuses from 1867 to 1914, the second from 1915 to 1961, and the third from 1962 to 2008. (You guessed it correctly, it is Canada. )

What I want to do is a scatter plot that shows the Canadian population growth over that time span, but I can’t figure out how to have only a single series show up in my chart for those three columns.

Thank you in advance, and God bless.

[LeroyG]

You can’t do it with XY (Scatter) but with Lines.
Edit the data range, and modify the Y-Values to show one column after the other.

LibreOffice Help on Chart Wizard - Data Range.

[GPWR]

Magnificent. For some reason, it wasn’t happy about the semicolon, so I switched it up for a comma and everything worked just fine(?) Thank you enormously for you help, and God bless you.

[LeroyG]

@GPWR

it wasn’t happy about the semicolon

See LibreOffice Help on Separators.

[Wanderer]

@GPWR

semicolon

Some countries use , in decimal numbers like 3,1415 - so using a semicolon as separator is quite useful in Germany…

[GPWR]

Some countries use , in decimal numbers like 3,1415 - so using a semicolon as separator is quite useful in Germany…

Makes sense. Thank you!