The problem is not in formatting. It was meant to be an example without actully providing any personal information.

I have a great number of individual spreadsheets for finanancial indicies and entities that I follow. Rather than scroll through numerous spreadsheets I I have used the URL method to have one composite spreadsheet that has a chart for each individual spreadsheet. I started doing that back with Sun’s Star 8 or 9. This has worked up until sometime in 2022/23, with various versions of Star, Apache, and LibreOffice. I am now using LibO 7.6.4.1.

The problem is that now you can neither Copy nor Create a chart that uses data from another spread sheet. by using either URL paths or by selecting the data from another spreadsheet.

Here are generic examples o fURL paths that have worked in the past:

Data Range ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIAHistory.ods’#$Sheet2.$A$41:$C$79,$Sheet2.$B$1:$C$1

Data Series:

Wks Avg Name ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA History.ods’#$Sheet2.$B$1:$B$1
x values ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA History.ods’#$Sheet2.$A$41:$A$79
y values ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA History.ods’#$Sheet2.$B$41:$B$79

Moving Avg Name ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA History.ods’#$Sheet2.$C$1:$C$1
x values ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA History.ods’#$Sheet2.$A$41:$A$79
y values ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA History.ods’#$Sheet2.$C$41:$C$79

Data Series:

Data Range ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ History.ods’#$Sheet2.$A$41:$C$79,$Sheet2.$B$1:$C$1

Wks Avg Name ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ History.ods’#$Sheet2.$B$1:$B$1
x values ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ History.ods’#$Sheet2.$A$41:$A$79
y values ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ History.ods’#$Sheet2.$B$41:$B$79

Moving Avg Name ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ History.ods’#$Sheet2.$C$1:$C$1
x values ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ History.ods’#$Sheet2.$A$41:$A$79
y values ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ History.ods’#$Sheet2.$C$41:$C$79