Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series equivalent in Excel 2000
Hi,
Using Series in a chart it's easy to use a dynamic range of data within a chart. Unfortunately I'm using Excel 2000 so the series function isn't available. When I enter the range name Excel converts it to the real cell range. The range name is defined as: =OFFSET($B$1,COUNTA($E:$E)-70,0,70,1) (translated from dutch excel version) Is it possible to update the chart range automatically, maybe using the named range? Thanks for your effort. Kind regards, Gert |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series equivalent in Excel 2000
In any version of Excel (97 through 2003) this is the behavior: you can
enter a range name into the data range box, and Excel will convert it to the range address. You can only use range names as definitions for pieces of the source data, i.e., for the individual Name, X Values, and Y Values ranges of each series. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Gert" wrote in message ... Hi, Using Series in a chart it's easy to use a dynamic range of data within a chart. Unfortunately I'm using Excel 2000 so the series function isn't available. When I enter the range name Excel converts it to the real cell range. The range name is defined as: =OFFSET($B$1,COUNTA($E:$E)-70,0,70,1) (translated from dutch excel version) Is it possible to update the chart range automatically, maybe using the named range? Thanks for your effort. Kind regards, Gert |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series equivalent in Excel 2000
I meant to add that the SERIES function has been around since at least Excel
4, if not earlier. It is not a worksheet function: you access it by selecting a series in a chart. You can change the SERIES formula directly by editing it in the Formula box, or indirectly through the Source Data dialog, Series tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Gert" wrote in message ... Hi, Using Series in a chart it's easy to use a dynamic range of data within a chart. Unfortunately I'm using Excel 2000 so the series function isn't available. When I enter the range name Excel converts it to the real cell range. The range name is defined as: =OFFSET($B$1,COUNTA($E:$E)-70,0,70,1) (translated from dutch excel version) Is it possible to update the chart range automatically, maybe using the named range? Thanks for your effort. Kind regards, Gert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks from Excel 2000 dont work anymore in Excel 2003 | Excel Discussion (Misc queries) | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
pivotcell object to excel 2000 | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |