Magnetic tornadoes in the Sun's atmosphere