Solved

Graphing :  Which is best Access or Excel

Posted on 2013-01-27
5
398 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
  • 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 119

Assisted Solution

by:Rey Obrero
Rey Obrero 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

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 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

11 Experts available now in Live!

Get 1:1 Help Now