Can anyone help me make a graph? - Miata Turbo Forum - Boost cars, acquire cats.

Welcome to Miataturbo.net   Members
 


ECUs and Tuning Discuss Engine Management, Tuning, & Programming

Reply
 
 
 
LinkBack Thread Tools Search this Thread
Old 01-07-2013, 02:40 AM   #1
Senior Member
Thread Starter
iTrader: (1)
 
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 03:24 AM.
lazzer408 is offline   Reply With Quote
Old 01-07-2013, 09:15 AM   #2
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 72,868
Total Cats: 1,790
Default

dunno how to use Excel?

Attached Thumbnails
Can anyone help me make a graph?-plotinexcel.jpg  
Braineack is online now   Reply With Quote
Old 01-07-2013, 10:07 AM   #3
Murderator
iTrader: (76)
 
18psi's Avatar
 
Join Date: Apr 2008
Posts: 36,186
Total Cats: 2,582
Default

I always wondered how you guys did it.

And never knew it was so simple lol
18psi is offline   Reply With Quote
Old 01-07-2013, 12:23 PM   #4
Senior Member
Thread Starter
iTrader: (1)
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
Default

Quote:
Originally Posted by Braineack View Post
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   Reply With Quote
Old 01-07-2013, 12:33 PM   #5
Tour de Franzia
iTrader: (6)
 
hustler's Avatar
 
Join Date: Jun 2006
Location: Republic of Dallas
Posts: 29,114
Total Cats: 351
Default

...and this is why the minimum wage is too high.
hustler is offline   Reply With Quote
Old 01-07-2013, 12:50 PM   #6
Senior Member
Thread Starter
iTrader: (1)
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
Default

Quote:
Originally Posted by hustler View Post
...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   Reply With Quote
Old 01-07-2013, 12:52 PM   #7
Elite Member
iTrader: (2)
 
Join Date: Aug 2012
Location: Indianapolis
Posts: 3,325
Total Cats: 235
Default

Quote:
Originally Posted by lazzer408 View Post
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   Reply With Quote
Old 01-07-2013, 12:53 PM   #8
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 72,868
Total Cats: 1,790
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 online now   Reply With Quote
Old 01-07-2013, 01:00 PM   #9
Elite Member
iTrader: (13)
 
Join Date: Dec 2006
Location: Taos, New mexico
Posts: 5,702
Total Cats: 237
Default

ITT: 101 - Intro to business computing

7th grade skillz
Fireindc is offline   Reply With Quote
Old 01-07-2013, 01:04 PM   #10
Senior Member
Thread Starter
iTrader: (1)
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
Default

Quote:
Originally Posted by Braineack View Post
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   Reply With Quote
Old 01-07-2013, 01:08 PM   #11
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 72,868
Total Cats: 1,790
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 online now   Reply With Quote
Old 01-07-2013, 01:13 PM   #12
Tour de Franzia
iTrader: (6)
 
hustler's Avatar
 
Join Date: Jun 2006
Location: Republic of Dallas
Posts: 29,114
Total Cats: 351
Default

Quote:
Originally Posted by lazzer408 View Post
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   Reply With Quote
Old 01-07-2013, 01:42 PM   #13
Senior Member
Thread Starter
iTrader: (1)
 
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   Reply With Quote
Old 01-12-2013, 11:04 AM   #14
Junior Member
 
Join Date: Sep 2011
Location: finger lakes NY
Posts: 444
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   Reply With Quote
Old 01-12-2013, 11:56 AM   #15
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 72,868
Total Cats: 1,790
Default

i like sharing my superior knowledge
Braineack is online now   Reply With Quote
Old 01-12-2013, 02:34 PM   #16
Senior Member
Thread Starter
iTrader: (1)
 
Join Date: Aug 2006
Location: Illinois
Posts: 1,011
Total Cats: 7
Default

Quote:
Originally Posted by Braineack View Post
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   Reply With Quote
Old 01-12-2013, 02:42 PM   #17
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 72,868
Total Cats: 1,790
Default

how can we feel better about ourselves then?
Braineack is online now   Reply With Quote
Old 01-12-2013, 03:26 PM   #18
Senior Member
Thread Starter
iTrader: (1)
 
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   Reply With Quote
Old 01-12-2013, 03:42 PM   #19
Senior Member
iTrader: (22)
 
Join Date: Oct 2007
Location: bay area, ca
Posts: 551
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   Reply With Quote
Old 01-12-2013, 04:02 PM   #20
Boost Pope
iTrader: (8)
 
Joe Perez's Avatar
 
Join Date: Sep 2005
Location: Chicago (Over two miles from Wrigley Field. Fuck the Cubs. Fuck them in their smarmy goat-hole.)
Posts: 26,318
Total Cats: 1,916
Default

Quote:
Originally Posted by lazzer408 View Post
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   Reply With Quote
 
 
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
Raleigh: Fiberglass headlight scope, 1.6L ECU, AFM, Hardtop latches, more bigmackloud Miata parts for sale/trade 13 09-22-2017 01:34 PM
Back to Stock Part Out!! Turbo Parts, MS2 Enhanced 01-05, Suspension, and MOAR! StratoBlue1109 Miata parts for sale/trade 16 10-02-2015 10:39 AM
Noob to Miataturbo from MA JxPhan Meet and Greet 3 10-02-2015 03:17 AM
Going back to stock. Need some 1.6 parts. Trent WTB 2 10-01-2015 01:15 PM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 03:11 PM.