Payoff Chart

Hi guys,

Ive looked for 2hours on the Internet, asked some colleagues but just couldnt find a solution to this (I would think to be :-)) easy problem.

Ive created a Payoff chart, which gives out the payoff of a derivative depending on the payoff of a security. The payoff consists out of three straight lines, but my excel is just not able to normalize the x-axe as it sees the values as texts, and doesnt normalize.

This leads to the Fact, that the Payoff has a "kink" at the x-axe Value of 40%, because the 33% point has the same distance to 30% and 40%, rather than being in the mid of it...

I hope someone can help me, this is driving me nuts

kink_payoff.JPG

Many thanks and regards,
Julian

payoff_kink.xls

Hi shg,

many thanks for your prompt and perfectly helping response. Sometimes the Solution is so easy that you just dont see it :-)

Cheers,
Julian