frequency response in Excel

[Milzie]

Im trying to plot my frequency response in excel from 20Hz to 20,000Hz. When I select logarythmix scale using an XY scatter, I am unable to set the limits to anything other than 10Hz to 100,000Hz.

Anyone know how to modify the graph so it displays 20 to 20kHz only?

Thanks,

 

[MRehorst]

double click on the x axis. The format axis dialog box comes up.
Select logarithmic, and set the upper and lower limits in the boxes provided for that purpose.

MR

 

[planet10]

Im trying to plot my frequency response in excel from 20Hz to 20,000Hz. When I select logarythmix scale using an XY scatter, I am unable to set the limits to anything other than 10Hz to 100,000Hz.

Anyone know how to modify the graph so it displays 20 to 20kHz only?

I just did one of these this morning, and it wouldn't let me set the limits to anything but 10^n.

(i don't really like Excel, it really isn't very good)

dave

 

[Milzie]

double click on the x axis. The format axis dialog box comes up.
Select logarithmic, and set the upper and lower limits in the boxes provided for that purpose.

MR

Wont let me set the limits, unless it starts with 10, 100, 1000, 10000, or 100000

 

[BrianGT]

Im trying to plot my frequency response in excel from 20Hz to 20,000Hz. When I select logarythmix scale using an XY scatter, I am unable to set the limits to anything other than 10Hz to 100,000Hz.

Anyone know how to modify the graph so it displays 20 to 20kHz only?

Thanks,

I have tried this a few times before, and I haven't been able to do this. It always makes me keep it at 10 to 100k. I don't think that is possible with Excel. It is possible with Kaleidagraph, but I wouldn't worry about it...

--
Brian