bit-tech.net

Go Back   bit-tech.net Forums > Technology > Software

Reply
 
Thread Tools
Old 18th Nov 2007, 18:48   #1
Kipman725
When did I get a custom title!?!
 
Kipman725's Avatar
 
Join Date: Nov 2004
Location: UK
Posts: 1,753
Kipman725 has yet to learn the way of the Dremel
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
Kipman725 is offline   Reply With Quote
Old 18th Nov 2007, 19:03   #2
capnPedro
Hacker. Maker. Engineer.
 
capnPedro's Avatar
 
Join Date: Apr 2007
Location: North-East England
Posts: 4,381
capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.
I was bored....

http://www.mediafire.com/?ememb2xfjgx

Something like that?
__________________
There is no better previewing system than the 'Submit Reply' button.

I <3 Aquatuning & Enermax long time!
capnPedro is offline   Reply With Quote
Old 18th Nov 2007, 19:21   #3
Kipman725
When did I get a custom title!?!
 
Kipman725's Avatar
 
Join Date: Nov 2004
Location: UK
Posts: 1,753
Kipman725 has yet to learn the way of the Dremel
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
Kipman725 is offline   Reply With Quote
Old 18th Nov 2007, 20:15   #4
capnPedro
Hacker. Maker. Engineer.
 
capnPedro's Avatar
 
Join Date: Apr 2007
Location: North-East England
Posts: 4,381
capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.capnPedro is a hoopy frood who really knows where their towel is.
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!
capnPedro is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 11:18.
Powered by: vBulletin Version 3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.