I have a sheet with quality control reports from many city offices.
Each office has several Management Areas they cover (Last Post)
I need to alter the chart to show one office at a time, wich would include multiple MA's
I don't need to chart 2 offices at the same time.
So I thought if I could make a validation list of the offices that would populate the sumproduct I'm using for the chart, I could use a named range for the list of offices with the MA values listed for each and use the variable in the sumproduct for each office and grouped MA's

sumproduct(--(ma=officename)
ma= the column on the source data
officename= the validation list of group ma values

Does that make sense?
Mark