If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
suggestion for excel tool option | David Coleman | General Discussions | 7 | November 10th, 2005 03:33 AM |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
Excel should let me align data labels in different series (Excel . | dlearndeltondo | Charts and Charting | 0 | February 10th, 2005 08:45 PM |
Excel 2002 and 2000 co-install. Control Which Starts ? | cnuk | General Discussion | 2 | January 17th, 2005 08:07 PM |
Pasting from Excel Office 2000 vs 2003 | wiseman | Powerpoint | 1 | June 22nd, 2004 02:59 PM |