Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Graphing :  Which is best Access or Excel

Posted on 2013-01-27
5
Medium Priority
?
409 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 49

Accepted Solution

by:
Dale Fye earned 1400 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 600 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 49

Expert Comment

by:Dale Fye
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
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…
Suggested Courses

885 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