[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 802
  • Last Modified:

Excel series function not working in Excel

I'm trying to use the Excel series for automating some charting requirements  in Excel 2007.

But I keep getting an error: "That Function is not valid"

I'm trying examples from this site:
http://www.bettersolutions.com/excel/EXX823/VI014016331.htm

Below is an example I tried to cut and paste into my Excel.


=SERIES("North", {"Mon","Tue","Wed","Thu","Fri","Sat","Sun"}, {0.65,0.21,0.86,0.97,0.05,0.34,0.74}, 1)

Open in new window

0
Matthew_Way
Asked:
Matthew_Way
  • 3
  • 3
  • 2
  • +1
1 Solution
 
ExcelGuideConsultantCommented:
Did you downloaded all the updates for Excel 2007? Seems like you are outdated....
0
 
Carol ChisholmCommented:
The series function only works in a chart, not in the spreadsheet part of the workbook
0
 
Matthew_WayAuthor Commented:
OMG Office 2007 SP2 is 290MB, this will take some time as I'm currently in China on a slow internet connection.
( hope the link dosn't fail .... )
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
ExcelGuideConsultantCommented:
Actually, thats true indeed.....but see this on the website, you should use it that way:

Step 6 - Changing the Arguments  
  You can change any of the series formula arguments in four ways you can change the series name of a data series:  
  1) Overwriting the cell(s) which the argument refers to.  
  2) Using the Automatic Range Finders to move the source data.  
  3) Using the (Chart > Source Data)(Series tab).  
  4) Editing the Series Formula.  
  The only way to change the order of the data series is to either use the (Chart > Source Data)(Series tab) or to edit the series formula directly.
0
 
Matthew_WayAuthor Commented:
I hope this function works outside of the graph component.

Can someone who has an updated Excel 2007 please confirm that the above code snippet does work.

Thanks.
0
 
Carol ChisholmCommented:
I tried pasting it into a worksheet and got the same error as you. (Office 2007 SP
If you go to Formula Insesrt Function you will see SERIES is not a function like SUM or COUNT.

However if you create a chart, and click on a line in that chart you will see a series function.
And you can build the series function with values un curly brackets like the example.
But a series is part of a chart.

I'm running Office 2007 plain vanilla.
0
 
Rory ArchibaldCommented:
The SERIES function is only for chart series - what would you expect it to do in a worksheet?
Regards,
Rory
0
 
Matthew_WayAuthor Commented:
Well did the Office 2007 SP2 install....

@rorya: I'm not really sure what I expected.
Just getting a little frustrated!

What I'm doing is creating an Excel spreadsheet within a PHP application ( PHPExcel ).
Which produces a number of dynamic tables.
We want to chart these tables.

I define name ranges for the data.
( example:  name->GraphUserData = A2:G16 )
But the problem is when I use the name in select series data it resolves back to column:row
I want a way of telling Excel to chart a particular range automatically.
0
 
ExcelGuideConsultantCommented:
Wouldnt this be a dynamic chart then?

Lots of example can be found here:
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Its not just naming a range...
0
 
Rory ArchibaldCommented:
You can use named ranges but you need one for each series (and the axis labels) - you can't just use one for the whole chart.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now