SERIES function disappear

[Vimm]

I can't use SERIES in Excel 2007 (err msg, input function not correct)
even i cant find SERIES function at "Insert function" dialog
i disable Marco in Excel 2007, is it related?
Pls Help, Thank you

 

[David Biddulph]

What were you expecting SERIES to do for you as a worksheet function?

In Excel 2003, SERIES didn't exist in a worksheet, but only in a chart.

 

[Ms-Exl-Learner]

I think in Excel 2007 the Fill Series button is there in the following
Location.

Home>>Editing>>below the ∑ (Sigma) command button you can find a Down Arrow
Command button, click on it and you will get a drop down list and select
Series.

In other way press Alt+E+I+S continuously for getting the Fill Series Dialog
Box using the keyboard.

Remember to Click Yes, if this post helps!

 

[Vimm]

dynamic chart
something like
=SERIES("CHART NAME", XREG YREG, 1)

i study from the web
i even cant see the series tab from chart -> source data -> selecting

 

[Vimm]

click on it and you will get a drop down list and select Series.

i cant find series function here
its same as insert function

a dialog box appear after Alt+E+I+S,
but i dont know how to use and how to enter my arg.

thank you

 

[David Biddulph]

Some hints on 2003 to 2007 command mapping:
a.. http://office.microsoft.com/en-us/excel/HA101491511033.aspx
b.. http://www.rondebruin.nl/0307commands.htm
c..
http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9028218

Chart | Source Data - in 2003
becomes
Chart Tools | Design | Data | Select Data - in 2007

 

[Ron Rosenfeld]

I can't use SERIES in Excel 2007 (err msg, input function not correct)
even i cant find SERIES function at "Insert function" dialog
i disable Marco in Excel 2007, is it related?
Pls Help, Thank you

Normally, you would use the chart wizard to edit a data series.

However, if you want to "see" the function, put your chart on a chart
worksheet, then select a data series. You will then see the SERIES function in
the formula bar, and you can edit it there.
--ron

 

[Ron Rosenfeld]

Normally, you would use the chart wizard to edit a data series.

However, if you want to "see" the function, put your chart on a chart
worksheet, then select a data series. You will then see the SERIES function in
the formula bar, and you can edit it there.
--ron

Actually, you don't have to have the chart on a chart sheet, at least not in
Excel 2007. You can also have it embedded in a regular worksheet. Again, just
select the data series, and the SERIES "function" will show up in the formula
bar.
--ron

 

[David Biddulph]

Actually, you don't have to have the chart on a chart sheet, at least
not in Excel 2007. You can also have it embedded in a regular
worksheet. Again, just select the data series, and the SERIES
"function" will show up in the formula bar.

Same in Excel 2003.