View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How do I draw a graph in Excel

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!