ok i cleared up a lot of the data recorded from vagcom. basically the ones where ive changed gear and allowed the revs to drop and at the end of the run originally i just organised the the revs into ascending order through access them transferred it back to excel. this was made a lot easier as the time stamps were in ascending in the original CSV file. deleted the ones where the revs started to drop then exported to excel sorted revs into ascending before plotting the graph
if you look at the orange line (5280 rpm) and the line before hand (5160 rpm) the lines cross around about this area. remember that a perfectly running engine should cross at 5252. thus showing that torque and horsepower are related. the only thing is the sample rate varied through out the run if you look at the revs that are marked up some times the revs climb in 40's at other times its 120. in other places when the car was accelerating and sample revs were matched over several gear they were averaged out
i hope that this shows that power and torque are connected. you cant have one without the other it only depends on how the engine produce each one