If you right-click on a database (or pretty much anything in object explorer) you can select from a number of built-in reports.

Some of them have some charts and graphs.

You can also create your own custom reports.