Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 5th 09, 08:06 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 3
Default 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   Report Post  
Old May 5th 09, 08:24 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default 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
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93167

  #3   Report Post  
Old May 5th 09, 08:47 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 3
Default 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

Thanks for your trouble.

"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
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93167


  #4   Report Post  
Old May 5th 09, 09:52 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default 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

Thanks for your trouble.

"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

Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=93167)




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

  #5   Report Post  
Old May 5th 09, 11:36 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default 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   Report Post  
Old May 5th 09, 12:00 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default 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
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93167

  #7   Report Post  
Old 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
Default 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   Report Post  
Old May 6th 09, 06:50 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 66
Default 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
from the menu


"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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017