the following function works well for Excel 2003 but not for 2007. What is the problem?
=SERIES("UCL";{1,5};Mech233_X_bar_Chart_Example_1.xls!UCL;2)
UCL is defined name with given value
this function suppose to draw a horizontal line for next 5 points just by one given value. It is convenient instead typing all 5 or 10, 50 etc values just to make horizontal line.
But it seems to me syntax of the function for Excel 2007 has changed. I tried to guess but doesn’t work
… anybody heeeelp…….
Vlad
please e-mail me if you can at:
vladoneykov@yahoo.com
