Ask Your Question

Revision history [back]

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.