ECUs and Tuning Discuss Engine Management, Tuning, & Programming

Can anyone help me make a graph?

Thread Tools
 
Search this Thread
 
Old 01-07-2013, 01:40 AM
  #1  
Senior Member
Thread Starter
iTrader: (1)
 
lazzer408's Avatar
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
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; 01-07-2013 at 02:24 AM.
lazzer408 is offline  
Old 01-07-2013, 08:15 AM
  #2  
Boost Czar
iTrader: (62)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 79,493
Total Cats: 4,080
Default

dunno how to use Excel?

Attached Thumbnails Can anyone help me make a graph?-plotinexcel.jpg  
Braineack is offline  
Old 01-07-2013, 09:07 AM
  #3  
VladiTuned
iTrader: (76)
 
18psi's Avatar
 
Join Date: Apr 2008
Posts: 35,821
Total Cats: 3,481
Default

I always wondered how you guys did it.

And never knew it was so simple lol
18psi is offline  
Old 01-07-2013, 11:23 AM
  #4  
Senior Member
Thread Starter
iTrader: (1)
 
lazzer408's Avatar
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
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?
lazzer408 is offline  
Old 01-07-2013, 11:33 AM
  #5  
Tour de Franzia
iTrader: (6)
 
hustler's Avatar
 
Join Date: Jun 2006
Location: Republic of Dallas
Posts: 29,085
Total Cats: 375
Default

...and this is why the minimum wage is too high.
hustler is offline  
Old 01-07-2013, 11:50 AM
  #6  
Senior Member
Thread Starter
iTrader: (1)
 
lazzer408's Avatar
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
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.
lazzer408 is offline  
Old 01-07-2013, 11:52 AM
  #7  
Elite Member
iTrader: (2)
 
thenuge26's Avatar
 
Join Date: Aug 2012
Location: Indianapolis
Posts: 3,267
Total Cats: 239
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  
thenuge26 is offline  
Old 01-07-2013, 11:53 AM
  #8  
Boost Czar
iTrader: (62)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 79,493
Total Cats: 4,080
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  
Braineack is offline  
Old 01-07-2013, 12:00 PM
  #9  
Elite Member
iTrader: (13)
 
Fireindc's Avatar
 
Join Date: Dec 2006
Location: Taos, New mexico
Posts: 6,598
Total Cats: 561
Default

ITT: 101 - Intro to business computing

7th grade skillz
Fireindc is offline  
Old 01-07-2013, 12:04 PM
  #10  
Senior Member
Thread Starter
iTrader: (1)
 
lazzer408's Avatar
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
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.
lazzer408 is offline  
Old 01-07-2013, 12:08 PM
  #11  
Boost Czar
iTrader: (62)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 79,493
Total Cats: 4,080
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  
Braineack is offline  
Old 01-07-2013, 12:13 PM
  #12  
Tour de Franzia
iTrader: (6)
 
hustler's Avatar
 
Join Date: Jun 2006
Location: Republic of Dallas
Posts: 29,085
Total Cats: 375
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  
hustler is offline  
Old 01-07-2013, 12:42 PM
  #13  
Senior Member
Thread Starter
iTrader: (1)
 
lazzer408's Avatar
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
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  
lazzer408 is offline  
Old 01-12-2013, 10:04 AM
  #14  
Junior Member
 
DaveC's Avatar
 
Join Date: Sep 2011
Location: finger lakes NY
Posts: 433
Total Cats: 17
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?
DaveC is offline  
Old 01-12-2013, 10:56 AM
  #15  
Boost Czar
iTrader: (62)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 79,493
Total Cats: 4,080
Default

i like sharing my superior knowledge
Braineack is offline  
Old 01-12-2013, 01:34 PM
  #16  
Senior Member
Thread Starter
iTrader: (1)
 
lazzer408's Avatar
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
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.
lazzer408 is offline  
Old 01-12-2013, 01:42 PM
  #17  
Boost Czar
iTrader: (62)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 79,493
Total Cats: 4,080
Default

how can we feel better about ourselves then?
Braineack is offline  
Old 01-12-2013, 02:26 PM
  #18  
Senior Member
Thread Starter
iTrader: (1)
 
lazzer408's Avatar
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
Default

You can always challange them to a game of wits.

Attached Thumbnails Can anyone help me make a graph?-princess-bride.jpg  
lazzer408 is offline  
Old 01-12-2013, 02:42 PM
  #19  
Senior Member
iTrader: (22)
 
orion4096's Avatar
 
Join Date: Oct 2007
Location: bay area, ca
Posts: 550
Total Cats: 19
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
orion4096 is offline  
Old 01-12-2013, 03:02 PM
  #20  
Boost Pope
iTrader: (8)
 
Joe Perez's Avatar
 
Join Date: Sep 2005
Location: Chicago. (The less-murder part.)
Posts: 33,020
Total Cats: 6,588
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  
Joe Perez is offline  


Quick Reply: Can anyone help me make a graph?



All times are GMT -4. The time now is 04:12 PM.