| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SERIES function disappear
Ron Rosenfeld wrote:
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. Same in Excel 2003. -- David Biddulph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wrap text function causes data to disappear in cell (visually only | Excel Discussion (Misc queries) | |||
| Why do series names on charts disappear when re-opening excel? | Charts and Charting in Excel | |||
| Have a chart line completely disappear for a Series... | Excel Worksheet Functions | |||
| average function for a series | Excel Worksheet Functions | |||
| Refreshing pivot makes second data series line disappear from chart !!! | Excel Discussion (Misc queries) | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
