Can't find a solution with a graph

**Marpal86** · 01-25-2013, 03:27 PM

Greetings everyone,

I have two variables: x=Frequency (Ηz) and y=dB.

I can't figure out which graph to use

The graph should look like the picture example.png

Please give me directions on how to create such a graph, because I need to make more than one.

Thank you

**shg** · 01-25-2013, 03:34 PM

Scatter chart, logarithmic on the x axis and linear on y (decibels is already a logarithmic measure).

**Marpal86** · 01-25-2013, 03:45 PM

When i did the scatterplot it looked like this example.png

So it doesn't correspond with above example...

Please help me by giving me more precise directions on how to proceed, because I'm an excel noob :P

**Steve=True** · 01-25-2013, 05:08 PM

Hello Marpal86

Welcome to the forums

I would recommend doing a XY Scatter with Straight Lines and Markers.

Then change your Horizontal Axis to a Logarithmic Scale. Here it is in Excel:

LogorythmicScale.png

Steve=Tue

**6StringJazzer** · 01-25-2013, 05:38 PM

I would use Scatter With Straight Lines and Markers, and the right-click on the x-axis and select the option for Logarithmic Scale, base 10. Example attached.

**shg** · 01-25-2013, 07:27 PM

Right-click the x axis, Format Axis, tick Logarithmic. The minimum x value must be set to either Automatic or something > 0.

The data you have will never look like the first curve you posted; the first is a low-pass filter, and yours looks more like a bandpass filter.