• The site migration is complete! Hopefully everything transferred properly from the multiple decades old software we were using before. If you notice any issues please let me know, thanks! Also, I'm still working on things like chatbox, etc so hopefully those will be working in the next week or two.

Excel pros! Need some help.

J

J57ltr

New member
Ok,

So I have a bunch of .csv log files that I want to put into a graph. I have no problem making a graph, but since everything is in a different scale it's really hard to see. Things like O2 voltage are 0-1V while Ignition is -15-60* manifold is -20 Hg to +15 psi, MAF output is from 0-600 or so. So how do I have multiple Y axis with a single X axis for time?

thanks,

Jeff
 


in excel you can only have two vertical Y axes. select the series you want to put on the second axis. right click and in the properties select axis - secondary
 
Another thing that will help is to override the automatic scale min and max that Excel defaults to. Right click on the Y axis bar and get into the config window for the axis. Uncheck the auto scale box and force your own min and max values for the axis until you get the data to display the way you want.

Another option for you is to go with a 3-D bar or line graph. I think that allows you to have different y scales for each data series.

Or, you can normalize all the data to % instead of actual values. You'd have to keep track of what 100% is for each data series but then it would all display on the same 2D graph.
 
You must log in or register to reply here.
Back
Top