Dear all,

I am trying to display a series of variables along an exponential x-axis (frequency x amplitude). I have encountered a problem in both methods using Excel 2007.

1. Scatter Graph

On the scatter graph I can make the x-axis exponential and everything looks great (including tick marks) but there is a big space between the start of the axis and the first frequency/dB point as well as the last marker point and the end of the x-axis. I understand that I can make a minimum and a maximum in the axis options but because the values change I want it to truncate automatically and keep or pre-define tick marks at say log 100, 1000, 10000 ; 200, 2000, 20000 ; or maybe in Octave bands.

2. Line Chart

On the Line Chart, the graph truncates perfectly, but the x-axis can not be set to logarithmic scale and the tick marks are displayed as increasing numbers related to the random start point of the series eg: if the first data point is 158Hz the x-axis ticks go up at a certain rate according to that number.

My questions: Is there a way to set tick marks, which will correspond to whatever data is being used for the graph? Tick marks which stay as they are set.