We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now


Graphing in Access 2007

dastrw asked
Medium Priority
Last Modified: 2012-08-13
Our company is transitioning from Office 2003 to 2007.  Something I read in the Microsoft literature suggests that Excel-style graphs are available in Access 2007.  However it seems like the graphs are just the same-old MSGraph graphs.

Is there a way to create Excel-style graphs in Access without invoking Excel objects?  I like the Excel graphs where each curve has its own X and Y data set rather than MSGraph where every curve has to share the same set of X's.
Watch Question

I know you've asked this question before and must be frustrated. I think you may need to install the correct interop assembly dll as discussed in the link below.  However, one thing I don't understand from the prior discussions is why everyone is saying the excel graph object is not available in Access (except as an automation object).  I have Access 2000, and in that version I can place a form in design view, go to the Access command menu and select Insert > object> msExcelChart      
>>>>>>>>>>> (vs msGraphChart)


Hope this helps.


I have created Access 97 and 2003 forms with embeded Excel chart objects as well, but there is a major problem with inserting an Excel Chart as you suggest.

When you bring up an Access form that contains an Excel chart one of two things happens:
1) If you already have Excel up, then it will use the first Excel application you invoked to manage the Excel chart in Access, or
2) If you don't have Excel up, then it will bring up an Excel application (usually minimized and hidden)  to manage the Excel chart.

Now the Excel chart in Access is tied to an external Excel application.  As other Excel workbooks are brought up, modified, and closed there is an interaction between Access and Excel.  At times this can either cause the Access app to hang or the Excel workbooks to hang, expecially if Excel code in Access is modifying the Access chart, or macros in the Excel workbooks are modifying the workbook.

One has to take extreme and cumbersome measures to isolate the Excel application that is managing the Access chart from any Excel workbook that happens to be up.

The hope with Access 2007 was that the Excel code could be executed without the need to invoke an external instance of the Excel application that could interfere with other Excel-related work that the user might be trying to do simultaneously.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts


Thanks for all of the links.  Unfortunately they all contain info which I am already aware of.  I have created some rather sophisticated graphs with the MSGraph object embedded in Access.  However, I am greedy and I want/need more ... or at least my users do.

We bought a 3rd-party graph tool a while ago, but there were problems with deploying it to multiple users on a variety of platforms (Windows 2000, Windowxs XP, etc.)  So I was really hoping that embeded Excel graphs were a reality with Access to avoid those hassles.

Thanks for the points and grade.  Sorry I could not find the ms graph link you were looking for.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.