I was just wondering if anyone knows what this message means:

"Method 'Axes' of object' _Chart failed"

The Macro works fine in Excel 2003 but crashes in Excel 2007. The line which
seems to be casuing me grief is:

ActiveChart.Axes(xlCategory, xlPrimary).CategoryType = xlCategoryScale

Could anyone let me know what the problem could be.

Cheers