Graph with empty cells?
 

Hi,

I'm trying to build a simple macro that import a .txt files and making a
graph with these data. But the line of row varies from the imported files (2
rows up to 50). I dont want to plot empty cells.

I tried few things, like using edition, go to, cells, click constant... But
it doesn't work. I'm not good in VBA and I'm planning to do a lot of
different macro, so I want to use excel options. I tried to use defined names
to automatically update a chart range in excel, but I got a french version
and it doesn't reconize this function:

=OFFSET($A$2,0,0,COUNTA($A$2:$A$50),1)

Is this the good way to avoid plotting empty cells, or where can I change
the language of these function???

Best regards,

Alex Paquet