For those that plot VAG data in Excel, how can I plot boost/RPM on two axes, with....
#1
AudiWorld Expert
![](https://www.audiworld.com/forums/images/ranks/guru2.jpg)
Thread Starter
![Default](https://www.audiworld.com/forums/images/icons/icon1.gif)
the X-axis using the time stamps from the data.
So, if I were to graph these three items:
RPM
Requested Boost
Actual Boost
and I wanted:
the left y-axis to be RPM
the right y-axis to be mbar
and the x-axis to be from the recorded timestamps
How do I do this???
I see that I can use an XY Scatter with connecting lines and that will get me those three items on a single y-axis and timestamps as the x-axis. What this lacks is a 2nd y-axis to better show the two sets of graphs on the same chart.
OR, I could go to custom types and choose "Lines on 2 Axes" and that will put those 3 items graphed how I'd like, however the x-axis is divided by integer increments. It turns out that the data recorded by the VAG is not always exacltly even increments, so I'd much rather actually plot based on those timestamps.
So, does anyone know how to get the graph I want?
So, if I were to graph these three items:
RPM
Requested Boost
Actual Boost
and I wanted:
the left y-axis to be RPM
the right y-axis to be mbar
and the x-axis to be from the recorded timestamps
How do I do this???
I see that I can use an XY Scatter with connecting lines and that will get me those three items on a single y-axis and timestamps as the x-axis. What this lacks is a 2nd y-axis to better show the two sets of graphs on the same chart.
OR, I could go to custom types and choose "Lines on 2 Axes" and that will put those 3 items graphed how I'd like, however the x-axis is divided by integer increments. It turns out that the data recorded by the VAG is not always exacltly even increments, so I'd much rather actually plot based on those timestamps.
So, does anyone know how to get the graph I want?
#5
AudiWorld Expert
![](https://www.audiworld.com/forums/images/ranks/guru2.jpg)
Thread Starter
![Default](https://www.audiworld.com/forums/images/icons/icon1.gif)
ie, they are all 1-unit apart, yet when I actually look at the difference between timestamps, I see they vary from 1.13 to 1.40 seconds for this one particular section of data I have in front of me, when recording 3 blocks.
I'll try DAP's approach
I'll try DAP's approach
#7
![Default](https://www.audiworld.com/forums/images/icons/icon1.gif)
select "Format Data Series" and select the second tab "Axis" and select the "Secondary Axis" radio button. That should do it.
I'm guessing you want something like this:
<img src="http://pictureposter.audiworld.com/26345/block_115.jpg">
I'm guessing you want something like this:
<img src="http://pictureposter.audiworld.com/26345/block_115.jpg">
Trending Topics
#10
AudiWorld Expert
![](https://www.audiworld.com/forums/images/ranks/guru2.jpg)
Thread Starter
![Default](https://www.audiworld.com/forums/images/icons/icon1.gif)
your actual boost is lagging way behind the requested, and then the actual stays pressurized, even after there's no more request for it. It looks like the actual is shifted to the right as if the time stamps weren't plotted correctly - or the car has a problem.
Any of this true, that you know of?
Thanks for the info - yeah, that's what DAP said below and exactly what I wanted - thanks
Any of this true, that you know of?
Thanks for the info - yeah, that's what DAP said below and exactly what I wanted - thanks