L
Little John
Hello all. I'm trying to create a simple chart for a class I'm in. I want
the Y axis to be the Price, and the X axis to represent the quantities (QD,
QS). But I am having no luck getting Excel to realize that, probably since
Price is the dependent variable. So whenever I try to create the chart, I
have the Quantities showing up as the Y axis. And it is driving me up the
wall. Any advice? Here's the table data below:
Price QD QS
$6.00 5,000 55,000
$5.00 15,000 40,000
$4.00 25,000 25,000
$3.00 35,000 10,000
$2.00 45,000 -5,000
$1.00 55,000 -20,000
$0.00 65,000 -35,000
the Y axis to be the Price, and the X axis to represent the quantities (QD,
QS). But I am having no luck getting Excel to realize that, probably since
Price is the dependent variable. So whenever I try to create the chart, I
have the Quantities showing up as the Y axis. And it is driving me up the
wall. Any advice? Here's the table data below:
Price QD QS
$6.00 5,000 55,000
$5.00 15,000 40,000
$4.00 25,000 25,000
$3.00 35,000 10,000
$2.00 45,000 -5,000
$1.00 55,000 -20,000
$0.00 65,000 -35,000