If you only have the standard version of SharePoint Server and want to display some dynamic charts you may want to consider this free web part.
http://cid-62b84429c3a8a991.skydrive.live.com/browse.aspx/SharePoint
The Chart Web Part can be used to generate charts in the Windows SharePoint Services environment. The Web Part supports data coming from XML files and Web Part Connections, and it generates charts as either an server-side images or as VML. This Web Part works great in complementing the Data View Web Part to provide a powerful data reporting story.
Although it was designed for SPS 2003, it works fine on MOSS as can be seen below.