graph with 1 dependent and 2 independent variables

**beni12** · 05-10-2011, 01:42 PM

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

**Andy Pope** · 05-12-2011, 04:06 AM

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.

**ads4go** · 06-05-2018, 09:18 PM

Is there any way to make a 3d chart with 2 independent/1 dependent, where the x-axis is for one independent, y-axis is for the other independent, and the z-axis is for the dependent?

**protonLeah** · 06-05-2018, 09:41 PM

ads4go,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.