Dynamic column range for scatter charts

Hi,

I'm new to this forum, and to forums in general,
So please excuse me for any misunderstanding of the forum rules..


I'm using Matlab to export to Excel a data range.

Up until now, the data range had a defined number of columns, and using the OFFSET function, and the Named Range option I got what I needed.
I created a Workbook Template where I defined every series seperately in the 'Select Data...' option for charts and defined them as different series.
from Matlab I would create a renamed copy of the template, poured all the data into it, and that worked beautifully.

Now I want to export a data range with a variable number of columns (2-16).
What I did is to create a Named Range with Offset containing all the data range,
and in the chart 'Select Data...' option, I inserted the Named Range in the "Chart Data Range" box.
The problem is that this box doesn't keep the Named Range but turn in into the absolut range of the function's answer. And, so, I have nothing..

I guess I'm not the first one to ask this question... But I'm an internet moron, and I couldn't find what I want..

I don't know anything about VBS, but I'm quick to learn if it's needed.
If someone could, please, show me how the code to this requirement should look.
Or, can I create it as a macro code, I can manually activate after all the data is alreay saved in to workbook?

Thanks!

Yoolts.