Created attachment 142649 [details]
A problematic sample
The problem is initially described at https://ask.libreoffice.org/en/question/157488.
In the attached file, the charts at sheet "Page1" have their data ranges on the other pages of this spreadsheet: e.g., a complex definition with ='15287024548174887.xlsx'!Age for X names, and ='15287024548174887.xlsx'!Reject, ='15287024548174887.xlsx'!Decay_but_Serviceable, and ='15287024548174887.xlsx'!No_Decay for series (for the bottom histogram).
When imported to LibreOffice, all the charts get the own data table, thus unlinked from the sheets data. So, changing data e.g. at inputs.E2 (to 3000, to make the first bar the highest) doesn't modify the histogram.
Tested with: Version: 184.108.40.206 (x64)
Build ID: 0588a1cb9a40c4a6a029e1d442a2b9767d612751
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: ru-RU (ru_RU); Calc: CL
Confirm with Version: 220.127.116.11.alpha0+
Build ID: 59935c314945cdc365878a898317bfaa366fc36e
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
and Version: 18.104.22.168.alpha2+
Data table correctly linked in excel2010.
Chart broken in 4.1.