Charisma and effective leadership

How necessary do you think charisma is to effective leadership? When might it be more or less needed? Support your answer.