Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I draw a graph in Excel
I can draw a line chart o/k but not a graph that starts at x=0,y=0.
Obviously, this is because the x axis in Excel is divided up into domains, from 0 to 1, 1 to 2, 2 to 3, etc and x values are shown as mid-ordinate values. However, I want to plot the line graphs y=39000+3x, and y=2800+2x and show the crossoverpoint at 61000 where it should be, not at 61500! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I draw a graph in Excel
You need to make an XY chart
XY chart can also have lines on them Line charts are used when the x-values are categories (which could be numbers like zip codes but are not truly numeric in that no one ever does moth with them), XY are used when the x-values are actual numeric values best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "ColinC" wrote in message ... I can draw a line chart o/k but not a graph that starts at x=0,y=0. Obviously, this is because the x axis in Excel is divided up into domains, from 0 to 1, 1 to 2, 2 to 3, etc and x values are shown as mid-ordinate values. However, I want to plot the line graphs y=39000+3x, and y=2800+2x and show the crossoverpoint at 61000 where it should be, not at 61500! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I draw a graph in Excel
I don't understand what you are saying about a cross-over at 61000 or 61500.
From simple algebra the crossover has to be at X=2800-39000, i.e. X=-32000, and hence Y=-69600. If you are trying to look at that sort of data, then I'm surprised that you've used a line chart. Don't you want an XY chart? Have you been confused by Excel's misleading naming system for the chart types? -- David Biddulph "ColinC" wrote in message ... I can draw a line chart o/k but not a graph that starts at x=0,y=0. Obviously, this is because the x axis in Excel is divided up into domains, from 0 to 1, 1 to 2, 2 to 3, etc and x values are shown as mid-ordinate values. However, I want to plot the line graphs y=39000+3x, and y=2800+2x and show the crossoverpoint at 61000 where it should be, not at 61500! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I draw a graph in Excel
Hi David. It's for a simple little project I've been given in uni, plotting
the economics of buying a machine costing £39000 that machines parts at £2 /part, or a machine costing £28000 that costs £3 per part to operate. up to 11000 parts, the cheaper machine wins, but after that, the dearer machine scores. I am plotting cost on the y axis and numbers of parts on the x axis for both machines. The lines should cross at 11000 parts. Anyway, thanks David and Bernard for the tip on XY charts, I'll try it. ColinC "David Biddulph" wrote: I don't understand what you are saying about a cross-over at 61000 or 61500. From simple algebra the crossover has to be at X=2800-39000, i.e. X=-32000, and hence Y=-69600. If you are trying to look at that sort of data, then I'm surprised that you've used a line chart. Don't you want an XY chart? Have you been confused by Excel's misleading naming system for the chart types? -- David Biddulph "ColinC" wrote in message ... I can draw a line chart o/k but not a graph that starts at x=0,y=0. Obviously, this is because the x axis in Excel is divided up into domains, from 0 to 1, 1 to 2, 2 to 3, etc and x values are shown as mid-ordinate values. However, I want to plot the line graphs y=39000+3x, and y=2800+2x and show the crossoverpoint at 61000 where it should be, not at 61500! |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I draw a graph in Excel
So when you said y=39000+3x you meant y=39000+2x
and when you said y=2800+2x you meant y=28000+3x ? Now all is clearer! -- David Biddulph "ColinC" wrote in message ... Hi David. It's for a simple little project I've been given in uni, plotting the economics of buying a machine costing £39000 that machines parts at £2 /part, or a machine costing £28000 that costs £3 per part to operate. up to 11000 parts, the cheaper machine wins, but after that, the dearer machine scores. I am plotting cost on the y axis and numbers of parts on the x axis for both machines. The lines should cross at 11000 parts. Anyway, thanks David and Bernard for the tip on XY charts, I'll try it. ColinC "David Biddulph" wrote: I don't understand what you are saying about a cross-over at 61000 or 61500. From simple algebra the crossover has to be at X=2800-39000, i.e. X=-32000, and hence Y=-69600. If you are trying to look at that sort of data, then I'm surprised that you've used a line chart. Don't you want an XY chart? Have you been confused by Excel's misleading naming system for the chart types? -- David Biddulph "ColinC" wrote in message ... I can draw a line chart o/k but not a graph that starts at x=0,y=0. Obviously, this is because the x axis in Excel is divided up into domains, from 0 to 1, 1 to 2, 2 to 3, etc and x values are shown as mid-ordinate values. However, I want to plot the line graphs y=39000+3x, and y=2800+2x and show the crossoverpoint at 61000 where it should be, not at 61500! |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I draw a graph in Excel
Hi,
You problem is that you gave us the wrong formulas, they should be: =39000-3*A2 =28000-2*A2 If your X values are in the range A2:A20 and start at 0 and are incremented 1000 you will get the intersection at 11,000. If this helps, please click the Yes button. cheers, Shane Devenshire "ColinC" wrote: Hi David. It's for a simple little project I've been given in uni, plotting the economics of buying a machine costing £39000 that machines parts at £2 /part, or a machine costing £28000 that costs £3 per part to operate. up to 11000 parts, the cheaper machine wins, but after that, the dearer machine scores. I am plotting cost on the y axis and numbers of parts on the x axis for both machines. The lines should cross at 11000 parts. Anyway, thanks David and Bernard for the tip on XY charts, I'll try it. ColinC "David Biddulph" wrote: I don't understand what you are saying about a cross-over at 61000 or 61500. From simple algebra the crossover has to be at X=2800-39000, i.e. X=-32000, and hence Y=-69600. If you are trying to look at that sort of data, then I'm surprised that you've used a line chart. Don't you want an XY chart? Have you been confused by Excel's misleading naming system for the chart types? -- David Biddulph "ColinC" wrote in message ... I can draw a line chart o/k but not a graph that starts at x=0,y=0. Obviously, this is because the x axis in Excel is divided up into domains, from 0 to 1, 1 to 2, 2 to 3, etc and x values are shown as mid-ordinate values. However, I want to plot the line graphs y=39000+3x, and y=2800+2x and show the crossoverpoint at 61000 where it should be, not at 61500! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to draw Gaussian distribution graph | Charts and Charting in Excel | |||
How should I draw graph in Semi-log sheet | Charts and Charting in Excel | |||
How do I draw a semilog graph? | Charts and Charting in Excel | |||
Can I draw a tangent to a line in graph in Excel? | Charts and Charting in Excel | |||
how do i draw equillbrium graph? | Excel Discussion (Misc queries) |