Macros in custom menu not working properly

I wrote this code that is supposed to create graphs and automatically format them. I then made this custom menu that was to be used as an Add-In but whenever I try to run the macro from the custom menu, it won't run properly. Heres what I have as my code:

Please Login or Register  to view this content.

Here are the macros that it uses:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I realized that if I try running the macro on a sheet that does not contain the data it uses, that the macro will return a blank graph or a strange graph.

I'm not quite sure how to fix it. I've tried changing the macros so that they first go to the spreadsheet that contains the data before it does anything else but it still doesn't work. I'm completely stumped.

I figured it out. Nevermind.