The Macro Recorder in Excel 2007:-

Excel offers a macro recorder that is about 60% perfect for charts. Unfortunately, the last 40% is frustrating. Code that you record to work with one dataset is hard-coded to work only with that dataset. This behavior might work fine if your chart data occupies cells A1:E7 every single day, but if you might have a different number of customers each day, it is unlikely that you will have the same number of rows each day. Given that you might need to work with other data, it would be a lot better if Excel could record your actions of selecting cells when you use the End key. This is one of the shortcomings of the macro recorder.

Excel pros often use the macro recorder to record code and expect to have to then clean up the recorded code. While this approach works perfectly with pivot tables and many other features, it seems that Microsoft ran out of time or was not interested in hooking up the macro recorder for most of the chart formatting tasks. You therefore have to write that 13 code from scratch.