|
|
#1 |
|
When did I get a custom title!?!
Join Date: Nov 2004
Location: UK
Posts: 1,753
![]() |
Having problems producing graph
Hello I am trying to produce a graph of frequancy response for a filter and both excell and OO refuse to do a proper xaxis scale. The x axis values range from 1000 to 25000 and the y axis values from 0 to -45. I need a logrithmic scale on the xaxis but what happens is that I get a log scale but with only two values 1000 and 100,000 which is very silly! both OO and excell refuse to let me reduce the major and minor grid lines to lower values (they are on one and ten suprisingly). This is crazy can somone tell me what im doing or point me to some software which can produce a coherant graph of this data please:
Frequency 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2200 2400 2600 2800 3000 3200 3400 3600 3800 4000 4400 4800 5200 5600 6000 6400 6800 7200 7600 8000 8800 9600 10400 11200 12000 12800 13600 14400 15200 16000 16800 17600 18400 19200 20000 20800 21600 22400 23200 Db 0 0 0 0 -0.13 -0.13 -0.13 -0.19 -0.27 -0.35 -0.41 -0.55 -0.55 -0.84 -0.99 -1.14 -1.29 -1.45 -1.61 -1.94 -2.11 -2.45 -3 -3.39 -3.79 -4.44 -4.66 -5.13 -5.38 -5.63 -5.89 -6.16 -6.16 -6.16 -6.6 -7.32 -8.95 -10.59 -12.18 -14.11 -16.61 -20.7 -24.22 -29.57 -33.09 -36.98 -39.36 -43 -44.22 -46.72
__________________
Sn45g game server mod My Electronics Site![]() Hardware: 3400+ Sempr0n, 1GB RAM, 1.28TB local storage, x1950pro,Razer Viper,M$ comfort curve 2000,L70S + 17", Fujitsu 17" CRT Audio: HD-650's, PE congress amp, Sound Blaster AWE64, Soundblaster 24bit |
|
|
|
|
|
#2 |
|
Hacker. Maker. Engineer.
Join Date: Apr 2007
Location: North-East England
Posts: 4,381
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
__________________
There is no better previewing system than the 'Submit Reply' button.
I <3 Aquatuning & Enermax long time! |
|
|
|
|
|
#3 |
|
When did I get a custom title!?!
Join Date: Nov 2004
Location: UK
Posts: 1,753
![]() |
not quite the shape like that but the orignal values at the bottom with the distance between each xvalue changed rather than changing the actual xvalues.
__________________
Sn45g game server mod My Electronics Site![]() Hardware: 3400+ Sempr0n, 1GB RAM, 1.28TB local storage, x1950pro,Razer Viper,M$ comfort curve 2000,L70S + 17", Fujitsu 17" CRT Audio: HD-650's, PE congress amp, Sound Blaster AWE64, Soundblaster 24bit |
|
|
|
|
|
#4 |
|
Hacker. Maker. Engineer.
Join Date: Apr 2007
Location: North-East England
Posts: 4,381
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Now that's something I've never seen, either in Excel or on graphs in general.
Although I haven't seen all that many graphs.
__________________
There is no better previewing system than the 'Submit Reply' button.
I <3 Aquatuning & Enermax long time! |
|
|
|
![]() |
| Thread Tools | |
|
|