Hi,
I entered your values, gave each column a heading, hit the F11 key and
got a graph like the one you need..

Herman_KLF;333403 Wrote:
Hi All

I want to draw a "Demand" line graph. If the price of apples is $1 per
kg,
the demand would be 100kg, if the price is $2 the demand would drop to
90kg,
etc... The example values are like this:
$2 ... 100
$4 ... 90
$6 ... 85
$8 ... 74
$10 ... 60
$12 ... 50

I created 2 columns Cost and Demand. If i just click a graph button on
the
insert tab and select the graph, using the data in the columns it gives
me 2
sets of values.

What i need is the x-axis to be qty demanded and the y-axis, the
Price/kg.

thanx
Herman


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93167