In the Middle Ages this name was common in England due to the popularity of medieval tales about the Trojan War. It subsequently became rare, but was revived in the 20th century.
This name has been used in the English-speaking world since the Protestant Reformation. In America it received a boost in popularity after the birth of Esther Cleveland (1893-1980), the daughter of President Grover Cleveland [1].
The name was common in France during the Middle Ages, and was introduced from there to England, though it eventually became rare. Interest in it was revived by the character Melanie Wilkes from the novel Gone with the Wind (1936) and the subsequent movie adaptation (1939).