If I have 2 columns of data, sometimes Excel uses the first column as the x axis of the graph, and sometimes it treats it as a data series.  For example, I'm trying to plot a log graph.  I have 2 columns of numbers:
 

1	45
10	90
100	180
1000	360

Sorry, I stated the problem, but I did not ask the question  
 
Excel want the y-axis to be the numbers of the columns.  So instead of having a log scale ranging from 0 to 1000, in the following example, it goes linearly from 0 to 4, with 2 data series:  1-1000 and 45-360.  I want one data series, 45-360, with a logrithmic y-axis spanning from 0 to 1000.
 
My graph should plot the points (45,1), (90,10), (180, 100), (360,1000).  I believe it will form a straight line.
 
I've since figured out that I can choose log scale in custom chart type, but it still picks the extremes for me.

Quote from Mal   on 11/14/06 at 21:26:40:

 
I've tried both  

That did the trick.  Thanks  

I believe custom graph templates are available in office 2005 and later. but I have no Idea how to access them as I'm still content with my office 2K