charts and graphs with access

[dhx10000]

Hi Everyone,

I am about to embark on a big task of displaying charts and graphs with access. I've been using excel, but I'm hoping to leverage my SQL experience to better manipulate the data using access. In comparison to Excel how powerful are Access' charting/graphing features? Can you recommend books or other resources to help me along? I need to show trending data, everages on bar charts, line charts, by month, by week, etc..

Thanks,