Why doesn't my excel macro work after I tried to fix the size of my bar chart?

Question

I recorded and ran my macro. It worked fine until my bar chart came up. I had fixed the size of my graph so that all my variables would show up but when I ran the macro, it didn't fix the size of my chart! Instead it gave me an "error" and options of "end" "debug" or "help". Can someone help me?? Please? Thanks!!!

is it because macros don't record the change in size of graphs?

Answer 1

It all depends. Excel macros does not record everything. That is why it has the debug option. See where the program has halted and fiddle around.