Pixel tutorial series by Despain:

This set of tutorials is aimed at people using RPG Maker (mainly XP and VX/Ace, because there’s no size limit to the character sets and the scripting functionality allows users to use any number of frames in animating), but I’m positive that everybody will be able to utilize the lessons here. I love the RPG Maker programs because I’m a graphic artist—and I can’t learn a programming language no matter how many times I try—and they provide a great premade engine for someone like me to build something. I want to see more games that take advantage of RPG Maker’s great capability to use original graphics; and that’s one of the major goals of this whole thing.

I want to encourage you to not be afraid to make your own graphics for your game. It’s easier than you think and well worth it.