Do you have SP2 for office installed?
My xl2007 version increments the chart index when done manually or with code.