Can I Convert My Bode Plots to Logarithmic Scale in Excel?

[k31453]

Got excel spreadsheet.
in my excel worksheet "4" i plot bode plot for low and high pass.

Our lab experiement aim was measure two set of data and identify which one is low pass and which one is highpass filter.

But as soon as I am trying to put lograitham graph it is not allow me ?

I want to know am i doing right thing or not?

This is the excel file.

https://www.dropbox.com/s/0thxwsrk3n8wl4w/lab.xlsx

 

[berkeman]

Got excel spreadsheet.
in my excel worksheet "4" i plot bode plot for low and high pass.

Our lab experiement aim was measure two set of data and identify which one is low pass and which one is highpass filter.

But as soon as I am trying to put lograitham graph it is not allow me ?

I want to know am i doing right thing or not?

This is the excel file.

https://www.dropbox.com/s/0thxwsrk3n8wl4w/lab.xlsx

right-click your left vertical axis, and select "Format Axis". In the format dialog box, you have options to convert the vertical scale to logarithmic. You can probably do something similar with the horizontal frequency scale as well...