Her groundbreaking series of autobiographical images , The Ballad of Sexual Dependency -- in which she depicted herself and her friends , drag queens , Aids sufferers and drug addicts , having sex , sleeping and arguing -- promoted her to a position of international renown in the Seventies , establishing her as a favourite with art-loving celebrities such as Elton John and Paul McCartney .