Solved

Graphing :  Which is best Access or Excel

Posted on 2013-01-27
5
404 Views
Last Modified: 2013-01-27
Hi,

Hi I will be developing a fairly simple (smallish) Access database.

IN order to impress (!) my client I will be including a lot of graphs.

I find Access graphing a bit awkward (perhaps it's me?).
I find Excel graphing friendlier and easier.

So, I think I may develop in Access and use msquery in Excel to display the data in graph format etc.

Is Excel better at graphing?
Is the above approach sensible?
0
Comment
Question by:Patrick O'Dea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 350 total points
ID: 38824590
I personally find Access graphs to be clunky, but I have not had much need to play with them much since I moved to 2007, so I don't know whether the 2007/10/13 graph capabilities have improved much.

When I was doing a lot of graphs, I generally tended to use your Excel with msquery technique, or used Excel automation to push recordsets to Excel, and then change the Excel graph properties from within Access.  

The up side of the latter technique was that I didn't have a lot of links that had to be refreshed; the down side was that the user of the Excel workbook was not able to update whenever they wanted, without running the Access application.
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 150 total points
ID: 38824591
yes, i do the same.
it is a lot easier to format the graphs in excel.
0
 

Author Comment

by:Patrick O'Dea
ID: 38824728
Experts, thanks for your views.

Fyed, could you expand very briefly on your comments if possible. How do i do this ... Just give me a pointer and i can figure it out. See below

"or used Excel automation to push recordsets to Excel, and then change the Excel graph properties from within Access."
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38824875
It has been quite a while since I have done this.

Pushing the data to Excel via automation is done by declaring Excel objects in your code, using either the CreateObject or GetObject method to open a current instance of Excel, or open a new one.

The Excel Worksheet method CopyFromRecordset is used to paste an Access recordset into Excel, using syntax similar to:

sht.Range("A2").CopyFromRecordset rs

I cannot find any code examples at the moment for manipulating the Excel chart object from code, but the easiest way to do that is to record a macro, then play around with the chart, then stop recording and view the code associated with the macro.  It is not always the most efficient, but you can generally post here at EE in the Access and Excel topic areas to get good answers on the specifics.  Actually, I would not be at all surprised if you searched EE on 'Excel Chart VBA' or something like that you would get quite a few hits.
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 38824915
Thanks folks,<br /><br />great as ever!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

738 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