If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Line x=0
Hello,
How do I create a line through x=0 in a XY Scatterplot chart? I can plot (x, y) and y=0 but not x=0. I am graphing linear inequalities and identifying the feasible region for a mathmatics class. Thanks for the help |
#2
|
|||
|
|||
Line x=0
Hi,
Sure that's not a Line graph (category X axis) instead of a XY scatter (Value X axis)? Cheers Andy Joe Gabba wrote: Hello, How do I create a line through x=0 in a XY Scatterplot chart? I can plot (x, y) and y=0 but not x=0. I am graphing linear inequalities and identifying the feasible region for a mathmatics class. Thanks for the help -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Line x=0
No, I used the XY scatter with data points connected by smoothed lines. I
did try with a line graph, but still can't figure out how to get a verticle line representing x=0. My data points are below. y3 is y=0. x y1 y2 y3 -10 9.5 29 0 10 -0.5 -11 0 "Andy Pope" wrote: Hi, Sure that's not a Line graph (category X axis) instead of a XY scatter (Value X axis)? Cheers Andy Joe Gabba wrote: Hello, How do I create a line through x=0 in a XY Scatterplot chart? I can plot (x, y) and y=0 but not x=0. I am graphing linear inequalities and identifying the feasible region for a mathmatics class. Thanks for the help -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
Line x=0
Joe -
With the data arranged the way you have it on the worksheet, Excel unfortunately assumes (when there are only two points) the data series are in rows. But yours are in columns. So, with some object of the chart selected, from the main menu choose Chart | Source Data. On the Data Range tab, select Series in: Columns. If that choice doesn't fix everything, use the Series tab to rearrange existing X and Y values for a series, or add the other series. Separate topic: I don't understand why you are using "smoothed lines." For your example, with only two points, only a straight line is possible. - Mike www.mikemiddleton.com "Joe Gabba" wrote in message ... No, I used the XY scatter with data points connected by smoothed lines. I did try with a line graph, but still can't figure out how to get a verticle line representing x=0. My data points are below. y3 is y=0. x y1 y2 y3 -10 9.5 29 0 10 -0.5 -11 0 "Andy Pope" wrote: Hi, Sure that's not a Line graph (category X axis) instead of a XY scatter (Value X axis)? Cheers Andy Joe Gabba wrote: Hello, How do I create a line through x=0 in a XY Scatterplot chart? I can plot (x, y) and y=0 but not x=0. I am graphing linear inequalities and identifying the feasible region for a mathmatics class. Thanks for the help -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Line x=0
Confused.
A line with the coord pair of (-10,0)(10,0) will give you a horizontal line. If you want a vertical line you will need a data set more like (0,-10)(0,10) If you meant horizontal then as Mike pointed out your layout of data and heading is being misread by the chart wizard. Assuming data in range A13 just select the values, B13 and plot the data in Columns. You will then get 3 lines of 2 points with the y3 series running along the X axis. Cheers Andy Joe Gabba wrote: No, I used the XY scatter with data points connected by smoothed lines. I did try with a line graph, but still can't figure out how to get a verticle line representing x=0. My data points are below. y3 is y=0. x y1 y2 y3 -10 9.5 29 0 10 -0.5 -11 0 "Andy Pope" wrote: Hi, Sure that's not a Line graph (category X axis) instead of a XY scatter (Value X axis)? Cheers Andy Joe Gabba wrote: Hello, How do I create a line through x=0 in a XY Scatterplot chart? I can plot (x, y) and y=0 but not x=0. I am graphing linear inequalities and identifying the feasible region for a mathmatics class. Thanks for the help -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mozilla Firefox problem Please Hejp | shen923 | Publisher | 8 | May 16th, 2006 08:16 AM |
Word - to make the final line of a paragraph a different allignmen | LGFN | Page Layout | 8 | May 9th, 2006 11:57 PM |
Line Numbering... (Cannot GoTo)!? | Jeffrey A. Voigt | Page Layout | 0 | July 30th, 2004 07:24 PM |
Outlook 2003: annoying line wrap when quoting | Tony Gravagno | General Discussion | 10 | July 18th, 2004 12:17 AM |
Discontinue part of line in chart | Jon Peltier | Charts and Charting | 0 | April 1st, 2004 10:27 PM |