Excel hart has OLE onject errors in Access 2007

I am trying to build a chart on a form in Access 2007. I have already
created it in Excel and want it to look the same but it seems that the
formatting options are greatly reduced, fewer chart options, and formatting
variations in Access.
I tried to copy and paste the chart from Excel 2007 onto my Access form, and
gave it the query as the data source but got messages "The operation on the
OLE object failed. The OLE server may not be registered. To register the
OLE server, reinstall it."
If I remove the name of the query I get an identical chart to the one in
Excel, but I need it to reflect the data in the query, not a copy of the
data that I used for testing in Excel.

How do I create the chart in Access with the features and functionality
available in Excel?
Mich