Hi All,

I need to create a graph based on select data which is part of a bigger data set without copy pasting the revelant data to antoher sheet. Also would like it to be dynamic. Can i do it Somehow.

For eg.

a spread option is based on the spread between the two underlying prices. now this option will be a lot more valuable when the spread blows out. I want to create a graph for the spread based on the following dataset for only those times when the option is In the money( ITM). again, it should be dynamic( eg. if i chance the criterion to OTM, i should get a graph which shows the Spread when it is OTM...)

Date       Option Value                   Spread             Status

xxxx        yyyyyy                                  GGG                   ITM

aaa       bbbbb                                  KKKK               OTM

ccc        dddd                                    LLL                   ITM

Thanks!

Kanwaljeet

Thanks Argha!

I was crazy on that. how do i show two trends( or n trends) on the same graph..based on the same dataset .....dynaimcally... was thinking on the lines of Drop down menus, Choosing what i want to show and the graph does that( and changes scales automatically)....like want to show the Intrinsic and extrinsic value of an option on the same graph and then if i change my mind, show the volatility of the option( let us say that these three items are in three columns in the same dataset)

Thanks!

Kanwaljeet