Dear master,
I want to ask about excel problem.
How to add local scope of data to series value?
This is my step how to create local data range
Clik "formulas" tab >> clik data manager
I fill name, fill refers to with
=OFFSET(Template1!$B$3,Template!$M$5,0,10,1)
Then i choose Sheet1 scope.
Because i hope if i copy Sheet1, the copied of new sheet will define scope to local too.
I'll use the data range in Sheet1 to chart just in Sheet1, and data range in Sheet2 just used in chart in Sheet2.
If scope i defined as workbook i can use it in series value with this function
=Template.xlsx!Sensor1a
How i write the function if i use local scope for data range?
Sorry for my bad english, thank you.
I want to ask about excel problem.
How to add local scope of data to series value?
This is my step how to create local data range
Clik "formulas" tab >> clik data manager
I fill name, fill refers to with
=OFFSET(Template1!$B$3,Template!$M$5,0,10,1)
Then i choose Sheet1 scope.
Because i hope if i copy Sheet1, the copied of new sheet will define scope to local too.
I'll use the data range in Sheet1 to chart just in Sheet1, and data range in Sheet2 just used in chart in Sheet2.
If scope i defined as workbook i can use it in series value with this function
=Template.xlsx!Sensor1a
How i write the function if i use local scope for data range?
Sorry for my bad english, thank you.
