Hello there,
I have in my excel file 2 tabs:
one data tab called Data
one tab for a chart.

In the data tab i have 2 columns from witch i created 2 ranges.

In the other tab i inserted a line chart, and in the serie value i referenced the range as :
=Data!myRange

Once i save the file and i reenter the configuration of the chart the serie value is becoming :
=[0]!myRange

How can it be =Data!myRange all the time, please???
thanks