View Single Post
  #4   Report Post  
Andy Pope
 
Posts: n/a
Default

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