I want to make a libre office-file where I can import csv-files and plot a xy-graph from the data in the csv-files. At the moment I am able to import the csv-files, and make a simple plot in another sheet. However, I would like to be able to import multiple csv-files (one in each sheet of the document) and somehow be able to choose which one to plot in the graph-sheet. The sheets look like follows and the data in the csv-files are two columns wide but of different lengths.
The idea is that the user herself can import a csv-file and add it as a new sheet, and then just simply change some setting in the GRAPH-sheet to see her data in the plot.
Is this possible?
Best regards, Johanna