Using Excel charts in Access 2003???

[PZStraube]

Hello,

I am trying to determine how Access 2003 compares to Excel when it
comes to creating charts plus whether I should use Access instead of
Word for my reports.

I have a large Excel 2003 spreadsheet used for client reporting that
contain dozens of pretty intricate charts. I then link those charts in
a Word file and create my reports from Word. In the Excel file, I have
numerous queries to bring in the underlying data from Access for each
chart. I am wondering if I could instead do most or all of this in
Access 2003 since I think could make better, more customized reports in
Access.

My main problem are the Excel charts. They are very complex plus must
be customized for each client (e.g., scale, etc.) using very long Excel
macros. I am concerned that I am stuck with Excel because I don't think
that Access can make these types of charts. I suppose one option would
be just to somehow link the Excel chart into Access report. Then I
could create my report text using formulas from the underlying data.

Thanks for yout thoughts on this as I begin learning more and more
about Access.