I have been using RRDtool for a while now, for graphing the traffic on my home ADSL. It's a huge improvement on MRTG, but fairly hard work to use by itself, as you have to write your own data collection scripts. So, having come into contact with Cacti at work, I decided to switch to that. This is an example of a really great open-source network app, with a very slick and powerful web interface.
I was surprised, though, at there being no included script or graph template for monitoring Apache stats. So I have written one. This tarball contains the script, template to import into cacti, and instructions. Very much a first draft, though.
PS. Looks like I should have searched Freshmeat and not Google, as there is a package called ApacheStats for cacti. Ah well — I prefer the presentation of my graphs.