any Microsoft Excel macro experts here?

[surfn]

I need some serious help with a Microsoft Excel macro program I am writing. I keep getting an error back when I am trying to apply a standard error formula to a graph, it only gives me an error when executing macro program.

 

[J. Montgomery]

I've used Excel a ton, as well as macros, but I've never written any myself :(

Can you go through them line by line to see when it hits the error?

 

[twon8]

ive used excel, i've got a friend who used to write macros all the time, but unless you could explaln the problem well i don't think i could convey it.

 

[Russellaqua]

I've used it a lot as well. I'd need a better explanation of the situation to help.

 

[surfn]

thanks guys, basically, i'm graphing some data that is insanely repetitive.......about 20 worksheets per file, and each worksheet has 2 data series with about 90 points. each data series is actually the average of 4 other series. so basically, on the graph, you can make it so it shows statistical standard error at each point...represented by a vertical line that goes above and below the point. the greater the standard error, the larger the vertical bar.

i know how to do all that.

but when i try to do the macro, it keeps giving me an error, and when i go to debug it...i look at the code and i have no idea what is wrong with the line of code it shows as a problem.

FWIW...i did VB coding back in highschool, as well as other program languages.....so i'm pretty efficient at being able to copy/paste code from a designed macro etc. i just can't figure out what is wrong with this one function. i can get it to graph everything correctly in the macro, i just can't get the standard error to work on the macro.

i'll post some pics in a bit when i get my laptop out with all the data on it.

 

[surfn]

alright, so this is an example of what my data table looks like on 1 worksheet (they all look the same on each worksheet, but different numbers as each different worksheet represents a different variable)

(don't mind the red and blue boxes)

the data goes down about 140 rows. and there are 2 groups. the first group is 25-28, which is then averaged and graphed as a line. then the second group 29-32 is averaged and then graphed as a line. then the standard deviation of each row (i.e. each data point on the graph) is taken, and then the standard error (standard error is just the standard deviation divided by 2).

 

[surfn]

this is what the basic graph looks like showing the averages of 2 different series. on the upper right hand corner is the option i used to get to the standard error. although, the standard error it comes up with automatically is a percent, which i don't want since i calculated my own standard error. so i click on custom, and define my own by highlighting the column with my standard error numbers.

 

[surfn]

and this is what the graph looks like with the standard errors calculated for each point. they are represented by a vertical line that goes through the point. if the standard error is large, so is the vertical line.

 

[surfn]

ok, so thats all the easy part. but when i do it and record the macro, and then replay it....it comes back with an error. i'll post back what the code error looks like as soon as i get macros enabled and templates downloaded to my laptop.