View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How do I draw a graph in Excel

I don't understand what you are saying about a cross-over at 61000 or 61500.
From simple algebra the crossover has to be at X=2800-39000, i.e. X=-32000,
and hence Y=-69600.

If you are trying to look at that sort of data, then I'm surprised that
you've used a line chart. Don't you want an XY chart? Have you been
confused by Excel's misleading naming system for the chart types?
--
David Biddulph


"ColinC" wrote in message
...
I can draw a line chart o/k but not a graph that starts at x=0,y=0.
Obviously, this is because the x axis in Excel is divided up into domains,
from 0 to 1, 1 to 2, 2 to 3, etc and x values are shown as mid-ordinate
values. However, I want to plot the line graphs y=39000+3x, and y=2800+2x
and
show the crossoverpoint at 61000 where it should be, not at 61500!