put the top_categories.php file in your plugins directory
activate the plugin
modify your template to include the following PHP:
You can pass in an optional numeric value like:
to change the number of categories displayed. By default it shows the top 10 categories (by number of posts).