Petrol Head Thwarted by Technology

[Crash Test Dummy]

I have a massive Excel spread sheet with data logged from my ECU. I could tell you all sorts of irrelevant information about my throttle pot and injector correction, just because I can. Although like me you probably don't care.

I have 3 columns.

RPM, Injector Duration and AFR. I would like RPM as the x-axis. With the others on the same graph using seperate y-axises.

I tried every single combination of Graph, trawled through loads of google pages and some rather confusing microsoft help and am now truly baffled.

All I want to do is fix the map so I can enjoy the summer .

answers on a postcard....

Edited by Crash Test Dummy on Wednesday 13th August 20:04

[Saskia7]

Formula function?

Edited by Saskia7 on Wednesday 13th August 20:10

[loafer123]

Select the data range, click on the graph button and select the dual axis bar & line chart.

Once the chart is created, select the bar series and change to a line format.

Job done.

[spikeyhead]

You need to select all the data
Create an X-Y graph
once you've done that you'll get a graph with one Y axis.

Click on the line that you want for the right hand Y axis and you'll see how to change it to the "secondary axis"

[stuthemong]

graphs-> cutsom types tab -> lines on 2 axis.

Delete all the series.

Add your own series 1 data with x-axis labels (RPM), and then y-axis for AFR
Add your own series 1 data with x-axis labels (RPM) - this will be already populated, and then y-axis for in jector duration

done
post the results!

Edited by stuthemong on Wednesday 13th August 20:32

[Crash Test Dummy]

Stuthemong - I am ending up creating a graph where RPM is a plotted line.

Spikey head - my brain cant compute your intructions

http://www.filefactory.com/file/afeeb8/n/Cold_Star...

I have hosted the file. Please help.....first to help get a pack of Wotsits

[mybrainhurts]

Crayon...?

[ridds]

Excel is st and can only plot evenly distributed goups on one of the 3 axis.

Tried to plot 3D before.

Try Uniplot. Much better, if not that easy to work with.

[trooperiziz]

Crash Test Dummy said:

Stuthemong - I am ending up creating a graph where RPM is a plotted line.

Spikey head - my brain cant compute your intructions

http://www.filefactory.com/file/afeeb8/n/Cold_Star...

I have hosted the file. Please help.....first to help get a pack of Wotsits

Not sure if this is exactly what you are after, as I couldn't work out exaclty what you were asking but I had 5 mins.

X axis is the rpm in original order on the data log tab, or in numerical order on the sheet 1 tab.
The other two data sets are plotted as lines on the graph.

http://www.filefactory.com/file/86455b/n/Cold_Star...

[Crash Test Dummy]

trooperiziz - my hero

think I found my problem. My injectors are not functioning fast enough.

Edited by Crash Test Dummy on Wednesday 13th August 22:47

[trooperiziz]

Crash Test Dummy said:

trooperiziz - my hero

think I found my problem. My injectors are not functioning fast enough.

Edited by Crash Test Dummy on Wednesday 13th August 22:47

Personally I thought your squiggle was too squiggly, turn down the squiggle using squiggle pot -ve