SERIES function disappear
On Sat, 26 Dec 2009 20:50:37 -0500, Ron Rosenfeld
wrote:
On Sat, 26 Dec 2009 04:35:01 -0800, Vimm
wrote:
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
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
|