Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I specify column for named range of rows
I have a sheet on which new lines of data get added almost daily, the first
column being a time and date stamp. To keep things organized, I name ranges of rows, describing the time interval they contain. For example, the range $10:$500 could be named "June". Now I want to chart different time intervals in a chart only by changing the name in the SERIES function. For example, if I am plotting column B against time, I would want to specify like SERIES(,June A, June B). I know this syntax is not accpeted, but is there any way it can be done, specifying only the column and row-range name? (I have a lot of charted columns, so simply defining a new name for each column AND row interval is not practical.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OFFSET function in named range returning wrong # of rows | Excel Worksheet Functions | |||
Number of Rows & Columns in a Named Range | Excel Discussion (Misc queries) | |||
Picking out column in named range | Excel Worksheet Functions | |||
Selecting specific row/column from a named range | Excel Worksheet Functions | |||
Identifying single column within named range | Excel Discussion (Misc queries) |