You need to make an XY chart
XY chart can also have lines on them
Line charts are used when the x-values are categories (which could be
numbers like zip codes but are not truly numeric in that no one ever does
moth with them), XY are used when the x-values are actual numeric values
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"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!