paco
08-14-2014, 01:24 PM
HI,
Simple problem... :-)
I have a file that contains two collums.
I need to graph the first A collum "mm" to the second B collum "Force" from cell 13 downwards.
I import the file and recorded a macro for creating the graph.
I adapted the macro to run it all automaticly.
But the recorded part of the graph does not what I want it makes an other graph. wrong.jpg
if I manualy create from the same data a graph it works fine. correct.jpg
What do I do wrong?
As the file size is dynamic I also need to make variable to it accepts not fixed number of cells but looks if cell is filled and create the graph according to the filled cell when the data is imported.
Any help in the right direction would be appriciated.
Simple problem... :-)
I have a file that contains two collums.
I need to graph the first A collum "mm" to the second B collum "Force" from cell 13 downwards.
I import the file and recorded a macro for creating the graph.
I adapted the macro to run it all automaticly.
But the recorded part of the graph does not what I want it makes an other graph. wrong.jpg
if I manualy create from the same data a graph it works fine. correct.jpg
What do I do wrong?
As the file size is dynamic I also need to make variable to it accepts not fixed number of cells but looks if cell is filled and create the graph according to the filled cell when the data is imported.
Any help in the right direction would be appriciated.