Remember Me?

#1
May 5th 09, 08:06 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Mar 2009 Posts: 3
A very simple graph gives me headache!!

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

#2
May 5th 09, 08:24 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: May 2009 Posts: 1
A very simple graph gives me headache!!

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

#3
May 5th 09, 08:47 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Mar 2009 Posts: 3
A very simple graph gives me headache!!

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

"Pecoflyer" wrote:

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

#4
May 5th 09, 09:52 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: May 2009 Posts: 1
A very simple graph gives me headache!!

What you require is exactly what I get...
Any way you could post your original sheet ( leaving confidential data
out)?
(It's possible on our forum)

Herman_KLF;333428 Wrote:
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

"Pecoflyer" wrote:

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: 'The Code Cage Forums - View Profile: Pecoflyer'

(http://www.thecodecage.com/forumz/me...pecoflyer.html)
View this thread: 'A very simple graph gives me headache!! - The Code

--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14

#5
May 5th 09, 11:36 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: May 2009 Posts: 1
A very simple graph gives me headache!!

On Tue, 5 May 2009 09:52:23 +0100, Pecoflyer
wrote:

(It's possible on our forum)

This group? How? Or what is the group name?

#6
May 5th 09, 12:00 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: May 2009 Posts: 1
A very simple graph gives me headache!!

SuspendedInGaffa;333532 Wrote:
On Tue, 5 May 2009 09:52:23 +0100, Pecoflyer
wrote:

(It's possible on our forum)

This group? How? Or what is the group name?

'The Code Cage' (http://www.thecodecage.com)

--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14

#7
May 5th 09, 01:14 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 6,582
A very simple graph gives me headache!!

Put the demand in the first column and the price in the second column.
Select this range of data, and create an XY chart, not a line chart. Choose
a subtype that connects the markers with lines.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______

"Herman_KLF" wrote in message
news
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

#8
May 6th 09, 06:50 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Apr 2009 Posts: 66
A very simple graph gives me headache!!

Drawing Supply and Demand curves in Excel
http://www.tushar-mehta.com/excel/ch...mand/index.htm

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select

"Herman_KLF" 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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post John Brown Excel Discussion (Misc queries) 0 December 27th 08 09:02 AM John Brown New Users to Excel 0 December 26th 08 02:31 PM Ant Charts and Charting in Excel 1 August 24th 06 08:43 AM Larry Excel Worksheet Functions 0 July 21st 06 06:48 PM LordJezo Excel Discussion (Misc queries) 1 July 21st 06 06:03 PM

All times are GMT +1. The time now is 12:05 AM.