How do I specify column for named range of rows

H

hmm

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 dynamic named range for the values in a pie chart 1
Setting a range in a named range 3
How can I print rows that go outside of the page without shrinking the text? 0
Look Up Formula With Veried Search Range 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Would like to create customized named range 2
Copying Named Ranges in Chart Series 1
Clustered-Stacked-Column Combo Chart With Lines 2

Top