[Zasquatch]

Originally Posted by BmwFanFL

Thanks for this, very helpful.

I think it would be helpful to show a small graph shown underneath (similar to how volume or technical graphs are sometimes shown under stock price graphs) that shows RPM and maybe TPS (or something else), X-aligned with the main graph. This doesn't pollute the scales, and you don't need a high precision graph of RPM....

My 2 cents. Thanks again.

Not a bad idea..... Maybe I will just scale down RPM by 1000 or something. I'll think on it.

[nitehawk]

Originally Posted by Zasquatch

Not a bad idea..... Maybe I will just scale down RPM by 1000 or something. I'll think on it.

Great macro OP, I've been using it alot Any luck adding RPMs on either axis?

[Zasquatch]

Originally Posted by nitehawk

Great macro OP, I've been using it alot Any luck adding RPMs on either axis?

Nice, glad to hear it! I have been too busy lately to revisit that, but it really won't require much code at all... I just need the time to do it.

[BlueBimmer]

This is a great thread - it should be a sticky!

[new2the3]

On my mac, when I select my csv file, I keep on getting a runtime 1004 error. What gives?

[Zasquatch]

Originally Posted by new2the3

On my mac, when I select my csv file, I keep on getting a runtime 1004 error. What gives?

Just checked out your file and found the problem. You should be good to go now. Re-download the file from the first post and you shouldn't have any more problems!

[enrita]

just tried this at work on W7 for office version 2007 and its not plotting anything.... i have enabled macros. Also tested 2003 version , same problem.

[Zasquatch]

Originally Posted by enrita

just tried this at work on W7 for office version 2007 and its not plotting anything.... i have enabled macros. Also tested 2003 version , same problem.

post your .csv file (may need to rename it as something else, not sure) and I'll try it on my end.

[enrita]

Originally Posted by Zasquatch

post your .csv file (may need to rename it as something else, not sure) and I'll try it on my end.

attached thanks

[Lulz_M3]

Originally Posted by enrita

attached thanks

Sorry, i was nosey and peaked. Is that an old datalog?

[enrita]

Originally Posted by Lulz_M3

Sorry, i was nosey and peaked. Is that an old datalog?

what do you mean old? thats stage 2plus v401.

[Lulz_M3]

Originally Posted by enrita

what do you mean old? thats stage 2plus v401.

I didnt know if it was an "old" datalog from your car on OTS maps, or if it was a "new" datalog using a map you tweaked with ATR. What fuel are you using in this log?

[Zasquatch]

Not sure what your issue is, worked fine on my end. Are you getting any error windows?

Also, for the 2003 version, make sure you are using office 2003. I'm very curious why you are having trouble.. Maybe post a screenshot of when you get the error?

[enrita]

Originally Posted by Zasquatch

Not sure what your issue is, worked fine on my end. Are you getting any error windows?

Also, for the 2003 version, make sure you are using office 2003. I'm very curious why you are having trouble.. Maybe post a screenshot of when you get the error?

no errors, basically the log window doesnt show anything. just white. This on W7 office 2007

[Zasquatch]

Originally Posted by enrita

no errors, basically the log window doesnt show anything. just white. This on W7 office 2007

If you could post a screenshot that would help then. Is it a blank graph with x and y axis? Or just a blank white page? That's really strange if there's no errors. We will figure it out though

[enrita]

Originally Posted by Lulz_M3

I didnt know if it was an "old" datalog from your car on OTS maps, or if it was a "new" datalog using a map you tweaked with ATR. What fuel are you using in this log?

93 octane, OTS map

[enrita]

Originally Posted by Zasquatch

If you could post a screenshot that would help then. Is it a blank graph with x and y axis? Or just a blank white page? That's really strange if there's no errors. We will figure it out though

[Zasquatch]

Originally Posted by enrita

LOL I name my plots the same thing!

Ok, this should be an easy fix I hope. I have the Y1 and Y2 axis set to "autoscale" so with this log it is getting confused. Double click on the left Y axis number and change the max value to 20. Do the same for Y2 (the right Y axis) and change it to 200.

You may need to do the same for the X axis, but start with the Y for now.

If that doesn't work, post a screenshot of the data table on the next tab.

[enrita]

didnt work

[Zasquatch]

Originally Posted by enrita

didnt work

Hmmmm... This is strange. You have a legend with series labels and the data sheet looks good. What does it look like when you go into the chart options and check the data series?

[Zasquatch]

Added a new version for Office 2007-2010 and Office OSX 2011 with some new buttons, a link to email questions/comments, and a button to make donations

Note that updates for Office 2003 will essentially be stopping. All my computers have been updated to newer versions, so it is getting more difficult to find one to work with. The file has been updated with the email and donations links mentioned above, but I have no way of testing code at this time. (Note that if enough people require 2003 support, I can hunt down an older system for testing)

[enrita]

still not working