MS Excel 2007 SERIES function

posted by VladoNeykov on Mar 17, 2008

Report abuse

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

Have the same problem? Click Here

This Problem has been added to the Share Your Expertise Page under "My Work Queue".

Solution #1

posted on Mar 20, 2008

mcc99

Rank:

Guru
Rating: 85%, 39 votes

First thing: Have yo downloaded *all* the updates available for Office 2007 from Windows Update?

Was this solution helpful? Show your Appreciation by rating it:

Inappropriate Thanks for Trying Helpful FixYa!

Suggest a new solution for this problem
Post a New problem for Business and Productivity Software
Email this problem

This Problem Also Relates To: HP (J8994A) for ProCurve 5400 Series Sony ACID Loops - Ugly Remnants: Volume One Volume License for PC (855309750763) Sony Acid Pro 6 Professional Music Workstation Full Version for PC Cisco 1841 IOS Advanced Enterprise Services Upgrade Version Encore 3D HOME ARCHITECT HOME & for PC (13911) IBM 1-2-3 Millennium Edition for Windows 9.8 (AN01NIE) for PC Microsoft Office 2003 Basic Edition English (s55-00066) for PC

Can you Help with these Business and Productivity Software problems?

Microsoft Office Professional 2007 Full...
Number convert in word

I want to write a number in... Answer This...

Adobe Photoshop® Elements 5.0 Full Version...
Emailing attachments.

The block asking for the... Answer This...

Microsoft Office 97 Professional Edition +...
Microsoft Access Problem

Size of my access database has... Answer This...

Microsoft SQL Server 2000 Standard Edition...
UPDATE DATA WINDOW IN PB 11...

sqlstate = 22001 error comes... Answer This...

Microsoft Office Professional 2007 Full...
need help

i need the key of microsoft... Answer This...

Benim

Let one of our
Experts Solve
your Problem

Repair Service

Find Business and Pro. Repairman Near You:

Advertise Here

Continue

FixYa does not evaluate or guarantee the accuracy of any information provided through its proposed solutions, posts, or Expert Assistance Sessions. By entering this site you declare you read and agreed to its Terms. You may NOT copy or distribute the content that appears on this site without written permission from FixYa Inc.

MS Excel 2007 SERIES function

Thank You!

Can you Help with these Business and Productivity Software problems?