P
Phil Newman
Hi,
I have this named formula (insert, name, define)
where the name is "test" and the formula is:
="Data'!$R"&(MATCH($D$35-$D$36,Data'!$A$13:$A$513)+12)&":$R"&(MATCH($D
$35,Data'!$A$13:$A$513)+12)
which outputs a text data range;
'Data'!$R22:$R71
which is exactly what i want.
what I now want, is to plot the values in this data range.
How can I do this?
Phil
I have this named formula (insert, name, define)
where the name is "test" and the formula is:
="Data'!$R"&(MATCH($D$35-$D$36,Data'!$A$13:$A$513)+12)&":$R"&(MATCH($D
$35,Data'!$A$13:$A$513)+12)
which outputs a text data range;
'Data'!$R22:$R71
which is exactly what i want.
what I now want, is to plot the values in this data range.
How can I do this?
Phil