dynamically graph with formula

[mike21mcd]

Kind of complex, but I will do my best to explain.

Worksheet A contains my main data. Worksheet B - G are graphical representations of certain aspects of the data. These graphs will change dynamically as the data on Worksheet A changes on a monthly basis.

Column B of Worksheet A contains index codes (gnof, fnof, fhof, fnnf, gnnf, etc...), and column A of Worksheet A contains different index codes (1yrlibor, 1yrcmt, etc...). Column D of Worksheet A is a numerical value.

I need the graph on worksheet B to graph by Column M index codes. However, multiple index codes from Column B can be associated with a single index code from Column M, and I need to be able to decipher which index codes in Column B I want read.

For example, Index Code in Column M is 1YRLIBOR. I want certain index codes in Column B that have that 1YRLIBOR index to be associated, and then for the total value of the numerical values in Column D to be summed where the colulmn B & M criteria are met.

does this make any sense and can anyone help? Thanks.

[tuph]

Perhaps if you zip and attach a copy of your workbook someone could look at it for you.