Another suggestion:
Plot your data as normal - e.g.
Qd P
0 30
25 25
50 20
75 15
100 10
125 5
150 0
Click on 'graph' then 'line'
Click on the 'series' tab
At the bottom where it says 'Category (X) axis labels:' click on the right
hand icon - it will shrink to just that box.
Highlight the Qd series on your table - just the figures not the 'Qd' cell-
the cells appear in the shrunken box.
Click on the tab to get back to the 'Source Data' dialogue box.
Highlight Qd in the series box and click 'remove'
Voila!!
When you have finished labeling etc, click on the 'X axis' and in the
format axis dialogue box, uncheck the 'Value (Y) axis crosses between
categories'
You should end up with a perfect demand curve!
Andrew
--On 29 January 2004 22:21 +1100 rob <[log in to unmask]> wrote:
> on 27/1/04 7:23 PM, Steve Hurd at [log in to unmask] wrote:
> Excel is difficult to use to solve this problem
> The easiest way is to
> -one choose the scatter plot option as suggested below.
> -use the chart wizard to control how excel plots the data. (Under the
> data range tab select series and use it to change the way excel plots the
> data.) -So price is plotted on the y axis
> -Quantity supplied is plotted on X axis
> -Quantity demanded is also plotted on the X axis
> Another and perhaps easier way which sometimes work. Is as follows
> Excel be default plots the first column of data in a table as the X axis.
> Enter the Quantity Supplied as the first column of data and plot it
> against price as per normal Price in the second Column.
> Enter Qd in the third column of your table and paste it into the graph,
> but use paste special to do this and and select the option which will
> allow you to use the existing Quantity values ( do not replace existing X
> axis) Hopefully you will get your demand and supply graph. This method
> however is not as reliable as the first. Then in the next column
> Hope this helps
> RB
>
> Richard
>
> Try using the joined scatter graph option.
>
> Steve
>
>
> ----- Original Message -----
> From: Richard Young <mailto:[log in to unmask]>
> To: [log in to unmask]
> Sent: Tuesday, January 27, 2004 6:25 AM
> Subject: Using Excel to plot simple demand curves - I cannot do it :-(
>
> Hi List
>
>
>
> Unit 8.1 of the new Key Stage 3 ICT strategy is improving my confidence
> with Excel graphing ? one of my many IT blind spots. Hey I can even graph
> two variables temperature and rain for a city over 12 months.
>
>
>
> But can I get Excel to graph a demand curve from simple data like
>
>
>
> Price
>
> 10
>
> 8
>
> 6
>
> 4
>
> Qd
>
> 2
>
> 4
>
> 6
>
> 8
>
>
>
> Excel insists on plotting the above as a positive relationship!
>
>
>
> So if anyone on the list has worked this out, please share the xls J
>
>
>
> NB please do not send any attachments to the list
>
>
>
> Regards
>
>
>
> Richard Young
>
> Head of Business Education & ICT
>
> Deputy Head of Sixth Form (Year 13)
>
> Wood Green School
>
> Woodstock Road
>
> Witney OX28 1DX
>
>
>
> Tel 01993 702355
>
> Fax 01993 774961
>
> [log in to unmask]
>
>
>
>
>
>
----------------------
Andrew Ashwin,
Content Developer
Biz/ed
Institute of Learning and Research Technology
[log in to unmask]
http://www.bized.ac.uk
|