Ask Your Question

Conditionally change data range of a chart in CALC? [closed]

asked 2012-11-24 10:48:50 +0200

Astuur gravatar image

updated 2013-02-03 09:44:28 +0200

qubit gravatar image

Is there a way to make a chart inside a CALC sheet change the cell range that it displays, depending on a condition? It seems only ordinary cell ranges are allowed in the data range and series range input masks. There is a format checker in place.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 04:29:35.321668

2 Answers

Sort by » oldest newest most voted

answered 2012-11-25 13:13:30 +0200

Jean-Baptiste FAURE gravatar image

I am not sure if I understand well what you mean, but I have a spreadsheet with which I analyze output data from a computational code:

  1. sheet_1 is linked to a csv file (the output from the computational code)
  2. sheet_2 shows a chart and a drop-down list allowing to choose which line from sheet_1 to be drawn on the graph;
  3. sheet_3 extract from sheet_1 the list of available data to feed the drop_down list

The chart take its values from a copy of the data defined by the value selected in the drop-down list. The copy is made using INDIRECT function.

I can send you the file if what I described is corresponding to what you want to do.

edit flag offensive delete link more


Mercy, Jean-Baptiste! - You have well understood my question. My misunderstanding was, that I tried to enter a formula into the range of the chart, when I should have pointed to a fixed region and change its content, I think, I would gladly see your examples! Again my thanks!

Astuur gravatar imageAstuur ( 2012-12-06 06:56:51 +0200 )edit

You can find my example here:

Do not try to update the linked data when opening the file (data sheet linked to a csv file)

Jean-Baptiste FAURE gravatar imageJean-Baptiste FAURE ( 2012-12-10 20:08:45 +0200 )edit

answered 2012-12-06 15:08:21 +0200

ROSt52 gravatar image

This is not an answer to the question but a hint that there can be problems occur with the customization of the chart layout.

Please have a look at:

edit flag offensive delete link more

Question Tools



Asked: 2012-11-24 10:48:50 +0200

Seen: 1,215 times

Last updated: Dec 06 '12