View Single Post
  #3   Report Post  
timcroot
 
Posts: n/a
Default

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