Y scale for P. ie when P$= 2, QD=10 & QS=3 P needs to be Y scale

[Searabeara007]

I am trying to create a graph the compares Quantity Demanded and Supplied in
relation to a particular price to find the equilibrium (intersection).
The problem is, I have no idea how to make one row the Y scale in my graph.
and the other two (QD and QS) the two line graphs which should intersect.
For example at a price $0, the QD is 11 units and the QS is 0. At a price $
4 the QD is 9 units and the QS is 3 units. So as price increases/decreases,
demand and supply changes!

[Andy Pope]

Hi,

Maybe Tushar Mehta's page can help you out.
http://tushar-mehta.com/excel/charts/supply_and_demand/

Cheers
Andy

Searabeara007 wrote:
> I am trying to create a graph the compares Quantity Demanded and Supplied in
> relation to a particular price to find the equilibrium (intersection).
> The problem is, I have no idea how to make one row the Y scale in my graph.
> and the other two (QD and QS) the two line graphs which should intersect.
> For example at a price $0, the QD is 11 units and the QS is 0. At a price $
> 4 the QD is 9 units and the QS is 3 units. So as price increases/decreases,
> demand and supply changes!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info