There are leaders, and there are charismatic leaders. How does a leader become more charismatic?
I believe that "charismatic" isn't something you call yourself - It's something your audience / team / followers calls you.
In my experience charismatic people do tend to be extraordinarily passionate people.
So perhaps to become more charismatic - be more passionate.