Using Google Charts to Create Pie Charts from SQL Data: A Step-by-Step Guide

Automating Chart Generation in R: A Comprehensive Guide to PDF and PNG Output

Here's a complete solution for your problem: