LinkBack URL
About LinkBacks
extremis 
Hi,
could someone explain me this formula?
SERIES(XYZ!$D$1,'files1.xls'!MNRCALDATE,'files1.xls'!MNRCALPA,1)
thanks
Hi,
could someone explain me this formula?
SERIES(XYZ!$D$1,'files1.xls'!MNRCALDATE,'files1.xls'!MNRCALPA,1)
thanks
I think that may be a UDF that someone put together for you? I use 2007 and can find no =SERIES() function?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Unless it is from a chart where the =SERIES() "function" (because I'm not sure it really is a function) is used to define a given data series for the chart. If this is the case, then the first argument is the name for the data series, the 2nd argument is the "x/category data", the 3rd argument is the "y/value" data, and the final argument is the plot order (1 is the first series plotted, 2 is the 2nd series plotted, and so on). The MNRCALDATE and MNRCALPA would refer to named ranges in the specified file.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks