• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 614
  • Last Modified:

Graphing in Access 2007

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.
0
dastrw
Asked:
dastrw
  • 3
  • 2
1 Solution
 
puppydogbuddyCommented:
dastrw,
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)

           http://msdn.microsoft.com/en-us/library/15s06t57(VS.80).aspx

Hope this helps.
0
 
dastrwAuthor Commented:
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.
0
 
dastrwAuthor Commented:
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.

0
 
puppydogbuddyCommented:
Thanks for the points and grade.  Sorry I could not find the ms graph link you were looking for.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now