Thread: graph with 1 dependent and 2 independent variables

Hey guys

I want to make a graph in Excel where on the x-axis there are 2 independent variables (maturity and price) and on the y-axis is my dependent variable (volatility). My Excel vesion is 2010 and I have difficulties with making that in it. I attached an excel sheet with some numbers so that you can better see what I exacly want to do.

It would be great if someone of you can help me with that Thank you in advance!!

Beni

Quickest way to construct the chart is to insert a chart and use the Select Data dialog to add 2 series selecting the appropriate x and y values.

You then need to decide whether the series should actually be displayed on 2 horizontal axes.