Record Macro with Histogram

[La82]

Hi Everyone,

I am completely new to macros in Excel, but have some analysis that always gets done the same way and is rather time consuming, so I figured I would give it a try.

I have four data sets that I have to make 8 histograms from.

I the cummulate the histograms two and two to get 4 histograms all together (see attached file (had to remove alot of data to make it fit, but I hope it illustrates the problem)).

Since I always use the same intervals (but the data length varies) I figured I could record the setup and run it as a macro.

When I try to run the macro it says: error 1004: somthing about not finding ATPVBAEN.XLAM

Can someone help me make this work? The general setup of the attached file is just the way I have done it manually - this can be changed to make the solution easier

Best Regards

Lonnie