A very simple graph gives me headache!!

  • Thread starter Thread starter Herman_KLF
  • Start date Start date
H

Herman_KLF

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
 
Nope, I got what i get the whole time, let me explain what i get:

There are 2 sets of values displayed on the graph, the cost values as well
as the values of the demands. X
I need only demand values and the other values should be the intervals on
the axis.


This would bee the graph that I need.

$14 |
$12 |
$10 |
$8 |
$6 |
$4 |
$2 |______________________________
0 20kg 40kg 60kg 80kg 100kg
Qty of Apples demanded

Thanks for your trouble.
 
Back
Top