Ask Your Question
0

Plot xy-graph with imported data in multiple sheets

asked 2017-12-20 09:13:56 +0100

johannan gravatar image

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-12-20 12:05:45 +0100

Lupp gravatar image

updated 2017-12-20 13:53:12 +0100

Charts are limited.
Mainly they do not accept calculated ranges (like for DataValidity e.g.).
In addition all the title elements (Title, Subtitle, Axis captions) are text constants.
The sheer data can be prepared in dedicated helper ranges of a sheet, but the size of the ranges, the chart type, the number of series ... all that needs to be fixed when the chart is created.

There are a few workarounds, by replacing chart titles with cell contents e.g, for the view/print. See this attached example.

Any parametrisation beyond that requires manipulation by user code, imo, and that code will not be exactly simple.

Hoping the user herself will be able to make useful use of this
Wolfgang

(Editing:)
Replaced the original attachment by a slightly enhanced one.

edit flag offensive delete link more
0

answered 2017-12-20 16:58:18 +0100

johannan gravatar image

Hi Wolfgang!

This was just what I needed! Thank you, you just made my day!

/ Johanna

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-12-20 09:13:56 +0100

Seen: 363 times

Last updated: Dec 20 '17