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
Bookmarks