Hello guys

I looking for a way to create a pie chart from a list.

The list is an overview of my expences an is done from a dropdown menu on each line (i.e. I buy some food and choose 'Food' from my dropdown menu. In the cell below I choose 'Office Supplies' for the stapler I just bought. And so on.)

My pie chart should automatically be updated when new posts in the list appear.

This way I can get a visual overview of my expences.

How do I do this?

I run Mac office 2007 - which means no VBA macros.. Can it be done without?

Thanks!
- Jesper