Min and Max in Range

[shelby55]

Hello

I am using Excel 2003.

I have a worksheet that is used to source a chart - the chart is on its own page as full page size. I've used named ranges for the graph source because I'm going to be entering new data each month. The named range for the months column is:

=OFFSET(DATA_P4R_admit!$A$8,0,0,COUNTA(DATA_P4R_admit!$A:$A)-1,1)

What I want to is create a title for the source of the data to place on the chart (via Camera). All but the last data point will be from one source and the last data entry from another. So if I have 6 data points for Jan to Jun I want to have formula which would read "Jan-11 to May-11 data is from DBA and Jun-11 is from DBB".

Any and all assistance greatly appreciated.

 

[SkipVought]

hi,

Is the issue that of the camera picture OR the range of data for the series?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[shelby55]

Hi

Thanks for responding Skip.

I need help with the formulae for the ranges...I know how to use the camera feature once the formulae are created.

 

[SkipVought]

I'd put your extra value into the series range.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[shelby55]

Hi Skip

Sorry but I'm not sure you're understanding what I'm requesting. What do you mean "put your extra value into the series range"?

In the example I gave, I'd like Jan-2011 to be the first value and May-2011 to be the max of the first range with the final value being on its own. How can I programatically do that? The named range I provided was for the entire range of the months in the graph.

Thanks.

 

[SkipVought]

I'm suggesting that you build a NEW range that is a combination of BOTH.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[shelby55]

Hi

And how do I do that? If I knew how to do that I wouldn't have posted the question in the first place, Skip. I don't have a problem with you asking questions to get people to think and help solve their own problems because you don't want to just give the answer but it's not helpful when the post becomes 50 posts long because you like being cryptic. If you don't want to help then please stop goofing with me. Thanks.

 

[SkipVought]

You have not defined where your second range comes from, I guess it's a range, for Jun 2011, But it could probably be done with a query.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}