Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

Graphing : Which is best Access or Excel

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
Patrick O'Dea
Asked:
Patrick O'Dea
  • 2
  • 2
2 Solutions
 
Dale FyeCommented:
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
 
Rey Obrero (Capricorn1)Commented:
yes, i do the same.
it is a lot easier to format the graphs in excel.
0
 
Patrick O'DeaAuthor Commented:
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
 
Dale FyeCommented:
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
 
Patrick O'DeaAuthor Commented:
Thanks folks,<br /><br />great as ever!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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