SERIES function disappear

  • Thread starter Thread starter Vimm
  • Start date Start date
V

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
 
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!
 
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
 
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
 
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
Click to expand...

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
 
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
Click to expand...

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
 
Back
Top