Can someone be charged with attempted murder and no one was hurt?

yes, of course!

Added: Just because you were not successful in your attempt doesn't mean that you didn't try to kill them.