Notices
ECUs and Tuning Discuss Engine Management, Tuning, & Programming

Can anyone help me make a graph?

Thread Tools
 
Search this Thread
 
Old Jan 7, 2013 | 01:40 AM
  #1  
lazzer408's Avatar
Thread Starter
Senior Member
iTrader: (1)
 
Joined: Aug 2006
Posts: 1,011
Total Cats: 7
From: Illinois
Default Can anyone help me make a graph?

...or point me to some software that can? I have bunch of dyno numbers that I need plotted.

I took some rwhp figures from an engine and added 15% to get this...

53.94hp 188.86ft 1500rpm
78.32hp 205.67ft 2000rpm
100.17hp 210.44ft 2500rpm
121.79hp 213.21ft 3000rpm
141.80hp 212.78ft 3500rpm
174.23hp 228.76ft 4000rpm
195.39hp 228.04ft 4500rpm
205.05hp 215.38ft 5000rpm
211.14hp 201.62ft 5500rpm

Can anyone help graph that?

Last edited by lazzer408; Jan 7, 2013 at 02:24 AM.
Old Jan 7, 2013 | 08:15 AM
  #2  
Braineack's Avatar
Boost Czar
iTrader: (62)
 
Joined: May 2005
Posts: 80,552
Total Cats: 4,368
From: Chantilly, VA
Default

dunno how to use Excel?

Attached Thumbnails Can anyone help me make a graph?-plotinexcel.jpg  
Old Jan 7, 2013 | 09:07 AM
  #3  
18psi's Avatar
VladiTuned
iTrader: (76)
 
Joined: Apr 2008
Posts: 35,821
Total Cats: 3,482
Default

I always wondered how you guys did it.

And never knew it was so simple lol
Old Jan 7, 2013 | 11:23 AM
  #4  
lazzer408's Avatar
Thread Starter
Senior Member
iTrader: (1)
 
Joined: Aug 2006
Posts: 1,011
Total Cats: 7
From: Illinois
Default

Originally Posted by Braineack
dunno how to use Excel?

Thanks Brain. Nope. Never had a need for it. How do you make the graph after the values are entered?
Old Jan 7, 2013 | 11:33 AM
  #5  
hustler's Avatar
Tour de Franzia
iTrader: (6)
 
Joined: Jun 2006
Posts: 29,085
Total Cats: 375
From: Republic of Dallas
Default

...and this is why the minimum wage is too high.
Old Jan 7, 2013 | 11:50 AM
  #6  
lazzer408's Avatar
Thread Starter
Senior Member
iTrader: (1)
 
Joined: Aug 2006
Posts: 1,011
Total Cats: 7
From: Illinois
Default

Originally Posted by hustler
...and this is why the minimum wage is too high.
Why's that? Because I don't use Excel? I'm a hardware guru not software. Excel is a tool I haven't needed. I don't have time to sit on my *** and learn it. I have things to do.
Old Jan 7, 2013 | 11:52 AM
  #7  
thenuge26's Avatar
Elite Member
iTrader: (2)
 
Joined: Aug 2012
Posts: 3,267
Total Cats: 239
From: Indianapolis
Default

Originally Posted by lazzer408
Thanks Brain. Nope. Never had a need for it. How do you make the graph after the values are entered?
With excel 2010 you literally just hit the 'line' button after you select your data.

Like I just accidentally made a graph without even knowing how.
Attached Thumbnails Can anyone help me make a graph?-srrkh.jpg  
Old Jan 7, 2013 | 11:53 AM
  #8  
Braineack's Avatar
Boost Czar
iTrader: (62)
 
Joined: May 2005
Posts: 80,552
Total Cats: 4,368
From: Chantilly, VA
Default

highlight coulmns a and b.



go to insert, then click line graph and the first option for a line graph.



it will insert one that looks close, but the x axis is 1-10.



right click the graph and click select data. under horizontal axis labels, click edit. select the values of the c column.



the end.



under the design tab, you can add in axis labeling and titles and such.
Attached Thumbnails Can anyone help me make a graph?-plotinexcel1.jpg   Can anyone help me make a graph?-plotinexcel2.jpg   Can anyone help me make a graph?-plotinexcel3.jpg   Can anyone help me make a graph?-plotinexcel4.jpg  
Old Jan 7, 2013 | 12:00 PM
  #9  
Fireindc's Avatar
Elite Member
iTrader: (13)
 
Joined: Dec 2006
Posts: 7,705
Total Cats: 904
From: Taos, New mexico
Default

ITT: 101 - Intro to business computing

7th grade skillz
Old Jan 7, 2013 | 12:04 PM
  #10  
lazzer408's Avatar
Thread Starter
Senior Member
iTrader: (1)
 
Joined: Aug 2006
Posts: 1,011
Total Cats: 7
From: Illinois
Default

Originally Posted by Braineack
highlight coulmns a and b.

go to insert, then click line graph and the first option for a line graph.

it will insert one that looks close, but the x axis is 1-10.

right click the graph and click select data. under horizontal axis labels, click edit. select the values of the c column.

the end.



under the design tab, you can add in axis labeling and titles and such.
Thanks again. The info is needed for this RX-8 v6 swap I'm doing. I'm comparing torque curves of this v6 vs. 13b-msp.
Old Jan 7, 2013 | 12:08 PM
  #11  
Braineack's Avatar
Boost Czar
iTrader: (62)
 
Joined: May 2005
Posts: 80,552
Total Cats: 4,368
From: Chantilly, VA
Default

I would do that a lot, then grow depressed:

Attached Thumbnails Can anyone help me make a graph?-april-10_vs_lars_dyno.jpg  
Old Jan 7, 2013 | 12:13 PM
  #12  
hustler's Avatar
Tour de Franzia
iTrader: (6)
 
Joined: Jun 2006
Posts: 29,085
Total Cats: 375
From: Republic of Dallas
Default

Originally Posted by lazzer408
Why's that? Because I don't use Excel? I'm a hardware guru not software. Excel is a tool I haven't needed. I don't have time to sit on my *** and learn it. I have things to do.
Attached Thumbnails Can anyone help me make a graph?-youmad.jpg  
Old Jan 7, 2013 | 12:42 PM
  #13  
lazzer408's Avatar
Thread Starter
Senior Member
iTrader: (1)
 
Joined: Aug 2006
Posts: 1,011
Total Cats: 7
From: Illinois
Default

It is impossible to hear one's tone of voice through text and thus it is impossible to sense their emotional state. If your expectations were to anger me, then you have failed. You have also proven it was your intent to provoke an unnecessary emotion. In other words, niggeh don't make me go all Data on yo' ***.

Attached Thumbnails Can anyone help me make a graph?-data_quotes_polonius_02.png  
Old Jan 12, 2013 | 10:04 AM
  #14  
DaveC's Avatar
Junior Member
 
Joined: Sep 2011
Posts: 433
Total Cats: 17
From: finger lakes NY
Default

It's reasonable to ask for help. It's not reasonable to ask the helper to invest more effort than you. Brain probably spent five minutes preparing that tutorial. Did you spend at least that much time with the Excel help system or Google before asking?
Old Jan 12, 2013 | 10:56 AM
  #15  
Braineack's Avatar
Boost Czar
iTrader: (62)
 
Joined: May 2005
Posts: 80,552
Total Cats: 4,368
From: Chantilly, VA
Default

i like sharing my superior knowledge
Old Jan 12, 2013 | 01:34 PM
  #16  
lazzer408's Avatar
Thread Starter
Senior Member
iTrader: (1)
 
Joined: Aug 2006
Posts: 1,011
Total Cats: 7
From: Illinois
Default

Originally Posted by Braineack
i like sharing my superior knowledge
I think knowledge has been our weapons against each other in the past.

DaveC - Of course I did. I downloaded 3 or 4 "free" programs designed to graph values but they ended up being graphing calculators. I didn't know Excel could do it. Not that I have $400 to drop on MS office anyway.

I enjoy helping others when I can. It saddens me knowing so many people would rather see others struggle then offer assistance.
Old Jan 12, 2013 | 01:42 PM
  #17  
Braineack's Avatar
Boost Czar
iTrader: (62)
 
Joined: May 2005
Posts: 80,552
Total Cats: 4,368
From: Chantilly, VA
Default

how can we feel better about ourselves then?
Old Jan 12, 2013 | 02:26 PM
  #18  
lazzer408's Avatar
Thread Starter
Senior Member
iTrader: (1)
 
Joined: Aug 2006
Posts: 1,011
Total Cats: 7
From: Illinois
Default

You can always challange them to a game of wits.

Attached Thumbnails Can anyone help me make a graph?-princess-bride.jpg  
Old Jan 12, 2013 | 02:42 PM
  #19  
orion4096's Avatar
Senior Member
iTrader: (22)
 
Joined: Oct 2007
Posts: 550
Total Cats: 19
From: bay area, ca
Default

docs.google.com

The spreadsheet program isn't as beefy as excel, but it will graph what you need and has a web interface.

EDIT: Check out: https://docs.google.com/spreadsheet/...waWhLakE#gid=0
Old Jan 12, 2013 | 03:02 PM
  #20  
Joe Perez's Avatar
Boost Pope
iTrader: (8)
 
Joined: Sep 2005
Posts: 34,402
Total Cats: 7,523
From: Chicago. (The less-murder part.)
Default

Originally Posted by lazzer408
It saddens me knowing so many people would rather see others struggle then offer assistance.
You're new to the internet, aren't you?

Attached Thumbnails Can anyone help me make a graph?-welcome-internet-ill-your-guide1.jpeg  



All times are GMT -4. The time now is 03:04 AM.