Import Excel chart (or image of chart) into Access
Experts,
As anyone who uses Access knows the charts are pretty bad compared to what you can do in Excel. I've got a really nice chart built in Access that is linked to a query in my Access file. Is it possible to import the chart from Excel back into Access? If not, how about importing or linking to it as an image?
Thanks, Dale
As anyone who uses Access knows the charts are pretty bad compared to what you can do in Excel. I've got a really nice chart built in Access that is linked to a query in my Access file. Is it possible to import the chart from Excel back into Access? If not, how about importing or linking to it as an image?
Thanks, Dale
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It should refresh every time you reload it, assuming your Excel sheet does so. Essentially, the OLE Object control just shows the object (in this case, and Excel file) as it would in the native environment (in this case, Excel).
Or do you mean something else?
Or do you mean something else?
ASKER
I will give it a try. Just "assumed without trying" it would need to be refreshed using VBA. The source is actually in the Access file where I am showing the chart. Just needed a much better chart than Access offers.
ASKER
I have the data connection in Excel set to refresh when the file is opened. So, refreshing the control in Access simply shows the chart as it were the last time the Excel file was saved.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've never used an unbound OLE Object control but was able to get this one to work. Maybe this should be a new question, but is there anyway to have the data used for the chart in Excel auto refresh?