Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 A1:D3 just select the values, B1:D3 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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
strange horizontal line showing accross several columns | Excel Discussion (Misc queries) | |||
Label an average line in a dynamic chart | Charts and Charting in Excel | |||
coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Line and Column Graph | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |