Being great is being recognized. To tell you the truth your question is kind of weird. Can't exactly understand what are you asking for what reason?
There are many great poets, sportsman or politicians and there many opposites of great.