Macro Recording Chart Format commands missing all important commands!!!!

Some times ago, SRuiter wrote:

Recorded Macro Missing All Useful Information

Excel 2007. I just recorded a macro of me editing the bars on a bar-chart. It was a totally useless excercise as it failed to record any important info. What I got is shown here:

Please Login or Register  to view this content.

I did a lot of formatting to each data series.

Any ideas out there?


I have exactly the same problem. If I can't record all the formatting commands, creating and manipulating diagrams with VBA is a pain. This error seems so big, that Ruiter and me can't be the only two having it. Do I oversee something obvious????

Thanks for help, or at least compassion :-)
it drives me crazy (VBA in general, but that the only easy help I can think of - recording all the format commands - is letting me down!!!)

cheers, noun ours

That's one of the bugs in 2007 that never got fixed. If you've got 2010 it did get fixed in it.

Thank you very much for this information.

I think that I tested on a Excel 2010 on one of the office computers though. I will double check this!!

thanks, nounours

Confirmed!!!
I retested on a Excel 2010 in our company, it works. So, I will stop bother on move to 2010 (well, don't like that, but ...).

Thanks Yraen!!

nounours

Do what I did, record in 2010 and write it in 2007.