How to make chart out of a multi-sheet ods file ?

users
#1

Dear Friends,

I want to make a chart from content in a multi-sheet file.

As an example to illustrate, I use
https://ec.europa.eu/home-affairs/sites/homeaffairs/files/what-we-do/policies/borders-and-visas/visa-policy/docs/2015_consulates_schengen_visa_stats_en.xlsx
. I converted the .xlsx to .ods using calligrasheets.

I was able to open the resultant file into libreoffice. See
https://dropfile.to/Sks88Py

Now what I want to do is to make chart from say either page 2 or page
3 but unable to figure out how to do it ?

I am running Libreoffice 5.2.4.2.1 on Debian testing -

[$] libreoffice --version

LibreOffice 5.2.4.2.1 20m0(Build:2)

Looking forward for a solution.

#2

W
​hen creating a chart​, you can either prefix your intervals with
$<sheetname>. or use the button on the right of each range input then
change tab to get data from another sheet.

Additionaly, to use multiple ranges (either on the same sheet or on various
sheets) you can separate ranges using a semicolon, and/or add more data
ranges in the chart assistant.

For example, this is a multi-sheet multiple range
string: $Sheet2.$A$1:$A$7;$Sheet1.$B$1:$C$7

#3

at bottom :-

Now what I want to do is to make chart from say either page 2 or page
3 but unable to figure out how to do it ?

W
​hen creating a chart​, you can either prefix your intervals with
$<sheetname>. or use the button on the right of each range input then
change tab to get data from another sheet.

Additionaly, to use multiple ranges (either on the same sheet or on various
sheets) you can separate ranges using a semicolon, and/or add more data
ranges in the chart assistant.

For example, this is a multi-sheet multiple range
string: $Sheet2.$A$1:$A$7;$Sheet1.$B$1:$C$7

Could you be a bit slow - Think of telling your 5 year old brother.

I am pretty poor at chart-making unfortunately :frowning: