Solved

Import Excel chart (or image of chart) into Access

Posted on 2014-04-14
6
2,192 Views
Last Modified: 2014-04-25
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
0
Comment
Question by:dlogan7
  • 3
  • 3
6 Comments
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
No, you cannot import an Excel chart into Access.

You could use an Unbound OLE Object control on a form to show that chart. Just drop the control on the form and set the Object to your Excel workbook.

If you just want an image, then take a screenshot of the image and use the Image control to show that picture. If the image changes frequently, or if it needs to be dependent on the data in the form, then this may not be the best way to handle your issue, however.
0
 

Author Comment

by:dlogan7
Comment Utility
Scott,

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?
0
 
LVL 84
Comment Utility
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?
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:dlogan7
Comment Utility
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.
0
 

Author Comment

by:dlogan7
Comment Utility
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.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
You'd have to automate Excel to do this, if you need to open and then save the file. Without going into too many specifics:

Dim xl As Object
Set xl = CreateObject("Excel.Application")
xl.visible = False
xl.Workbooks.OPen "Full path to your xls file"

xl.Visible = False
xl.Workbooks.Open ""
xl.Workbooks(0).Save
xl.Quit

Set xl = Nothing

Open in new window


Do something like that just before you open the Access form.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now