Quote Originally Posted by firefytr
This is usually done with some sort of a)SERIES formula, b)an OFFSET function using named ranges, or c)INDEX/MATCH combo using named ranges (my personal favorite), or a combination. Just wondering if there was anything else you needed help w/ on this.
honestly i cant tell you which way fits, i have all our surgeons grouped together by their service... i enter the number of cases each surgeon does on a monthly basis and it gives me a total # per service.

on a seperate sheet i have the grand totals showing up via a VLOOKUP field that refers to the first sheet. the chart is also located on this sheet and the source data for the chart is the collection of fields on the second sheet. as i enter each individual surgeon's total on the detail sheet, the total grows with it... as does the coinciding <sp?> cell on the second sheet. as the cell on the second sheet changes it changes the chart... the only draw back i have found is that - since i have all the VLOOKUP formulas already in place for the rest of this year, i have 0s for future months so you watch the data "travel" each previous month, and then plummet to zero for the months that are not completed yet... a bit irritating, yes, but it still does what it is supposed to and that is what is important.

i guess in theory i could remove the VLOOKUP fields for future months and then copy the ones from the previous month and see if that works (i cant think of a reason why it would not, but i have not worked much with VLOOKUP fields as of yet either)... i may have to play with that a bit...

thanks to both you and shades for all your help with this... i am humbled by yall's "gray matter" hehe