| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
X=y will not cross 0,0 why
On a simple line chart X=Y used as a demo, the line will not cross at 0,0
why??? |
|
#2
|
|||
|
|||
|
Hi tim,
Possible you are using Line chart instead of XY Scatter? To change right click and select Chart Type, pick xy scatter. Where does the line cross when x=0 and y=0? Cheers Andy tim wrote: On a simple line chart X=Y used as a demo, the line will not cross at 0,0 why??? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
Hi Andy
I seleected the simple chart to show a friend how easy it was and the line crosses the axis at .5,-.5. the line markers at the ends report 0,0 but the line isnt at these points???? How do I explain this to a new charter?? Tim "Andy Pope" wrote: Hi tim, Possible you are using Line chart instead of XY Scatter? To change right click and select Chart Type, pick xy scatter. Where does the line cross when x=0 and y=0? Cheers Andy tim wrote: On a simple line chart X=Y used as a demo, the line will not cross at 0,0 why??? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
|
|||
|
|||
|
what data did you use?
timcroot wrote: Hi Andy I seleected the simple chart to show a friend how easy it was and the line crosses the axis at .5,-.5. the line markers at the ends report 0,0 but the line isnt at these points???? How do I explain this to a new charter?? Tim "Andy Pope" wrote: Hi tim, Possible you are using Line chart instead of XY Scatter? To change right click and select Chart Type, pick xy scatter. Where does the line cross when x=0 and y=0? Cheers Andy tim wrote: On a simple line chart X=Y used as a demo, the line will not cross at 0,0 why??? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
|
|||
|
|||
|
data used was x=0 y=0, x=5 y=5 the chart was a simple line chart tim "Andy Pope" wrote: what data did you use? timcroot wrote: Hi Andy I seleected the simple chart to show a friend how easy it was and the line crosses the axis at .5,-.5. the line markers at the ends report 0,0 but the line isnt at these points???? How do I explain this to a new charter?? Tim "Andy Pope" wrote: Hi tim, Possible you are using Line chart instead of XY Scatter? To change right click and select Chart Type, pick xy scatter. Where does the line cross when x=0 and y=0? Cheers Andy tim wrote: On a simple line chart X=Y used as a demo, the line will not cross at 0,0 why??? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
|
|||
|
|||
|
Sorry tim, I can not create a chart with the data that doesn't produce
results as expected :( If you want to email me chart directly I will take a look. Or maybe somebody else has an idea why you chart is mis-behaving. Cheers Andy tim croot wrote: data used was x=0 y=0, x=5 y=5 the chart was a simple line chart tim "Andy Pope" wrote: what data did you use? timcroot wrote: Hi Andy I seleected the simple chart to show a friend how easy it was and the line crosses the axis at .5,-.5. the line markers at the ends report 0,0 but the line isnt at these points???? How do I explain this to a new charter?? Tim "Andy Pope" wrote: Hi tim, Possible you are using Line chart instead of XY Scatter? To change right click and select Chart Type, pick xy scatter. Where does the line cross when x=0 and y=0? Cheers Andy tim wrote: On a simple line chart X=Y used as a demo, the line will not cross at 0,0 why??? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cross referancing | Excel Discussion (Misc queries) | |||
| How to sum cross two categories? | Excel Worksheet Functions | |||
| How do I find a cross reference value | Excel Discussion (Misc queries) | |||
| Excel-value in a range of cells for two cross references | Excel Worksheet Functions | |||
Hybrid Mode
