Microsoft have just released KB937620: "You cannot record new shapes, shape
formatting, and shape effects by using the macro recorder in Excel 2007"

This means just what it says! If you want to play with Chart design you now
have to hand code the elements.

It also says "This behavior is by design"

Why would they deliberately remove this functionality?