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.