Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Plot xy-graph with imported data in multiple sheets

Hello!

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.

|_-_GRAPH_-_|_CVS_1_|_CSV_2_|_CSV_3_|_..._|_CSV_n_|

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