By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,369 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Access or Excel if You're Doing Lots of Charts?

P: n/a
I'm doubtful that the group is unbiased, but I will ask anyhow :o). If
one intends to plot lots of data, primarily XY line and scatter plots,
and mass produce them (in many cases I will be doing 88 graphs at a
time - 1 for each of 88 counties), will Exel be the best bet, or is
Access equally capable? I might mention that in time, I will be moving
all of my data into Access databases. I'm slowing learning charting
and automation in Excel, and I'd hate to spend much more time here if
it is going to be easier to work in Access. Any and all
comments/thoughts are welcome and appreciated.

Regards,
Mike

Jul 21 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
DFS
Takeadoe wrote:
I'm doubtful that the group is unbiased, but I will ask anyhow :o).
If one intends to plot lots of data, primarily XY line and scatter
plots, and mass produce them (in many cases I will be doing 88 graphs
at a time - 1 for each of 88 counties), will Exel be the best bet, or
is Access equally capable? I might mention that in time, I will be
moving all of my data into Access databases. I'm slowing learning
charting and automation in Excel, and I'd hate to spend much more
time here if it is going to be easier to work in Access. Any and all
comments/thoughts are welcome and appreciated.
First, you'll find nobody here cares about scatter charts. (ha! That's an
"inside joke" on cdma because I recently posted about doing scatter charts
in Access, and nobody answered until I got persistent on their @ss).

Anyway, it seems few here have any Access scatter chart experience, and
nobody was able to show me a reasonably attractive scatter chart drawn in
Access. But check out this one a colleague did in Excel
http://www.angelfire.com/planet/dfs0...er_example.PNG

I think you'll be better off with Excel charting, especially for scatter
charts. I don't know all the Excel scatter chart options, but I'm sure you
can put the data labels on it, axis labels, etc. If you later end up with
your data in Access, you can still query it from Excel and pull it into
Excel for charting.
Jul 21 '06 #2

P: n/a
Takeadoe <mt********@msn.comwrote:
: I'm doubtful that the group is unbiased, but I will ask anyhow :o). If
: one intends to plot lots of data, primarily XY line and scatter plots,
: and mass produce them (in many cases I will be doing 88 graphs at a
: time - 1 for each of 88 counties), will Exel be the best bet, or is
: Access equally capable? I might mention that in time, I will be moving
: all of my data into Access databases. I'm slowing learning charting
: and automation in Excel, and I'd hate to spend much more time here if
: it is going to be easier to work in Access. Any and all
: comments/thoughts are welcome and appreciated.

It sounds like we're working in similar areas [probably not
geographically, though]

I'm working with an existent database, designing and expanding
forms. What the people who originally designed the database did
was to write Excel workbooks within Access forms, so there's a
lot of VBA code involved. But having the very good Excel charting
facilities available seems to be worth it.

--thelma
: Regards,
: Mike

Jul 21 '06 #3

P: n/a
Thank you Thelma. I've been programming in SAS (Statistcal Analysis
Software) for nearly 20 years. I'm outnumbered here, however,as few
folks can even spell SAS. Thus, I'm in the process of moving the bulk
of the data to Access.

Take Care.

Mike
Thelma Lubkin wrote:
Takeadoe <mt********@msn.comwrote:
: I'm doubtful that the group is unbiased, but I will ask anyhow :o). If
: one intends to plot lots of data, primarily XY line and scatter plots,
: and mass produce them (in many cases I will be doing 88 graphs at a
: time - 1 for each of 88 counties), will Exel be the best bet, or is
: Access equally capable? I might mention that in time, I will be moving
: all of my data into Access databases. I'm slowing learning charting
: and automation in Excel, and I'd hate to spend much more time here if
: it is going to be easier to work in Access. Any and all
: comments/thoughts are welcome and appreciated.

It sounds like we're working in similar areas [probably not
geographically, though]

I'm working with an existent database, designing and expanding
forms. What the people who originally designed the database did
was to write Excel workbooks within Access forms, so there's a
lot of VBA code involved. But having the very good Excel charting
facilities available seems to be worth it.

--thelma
: Regards,
: Mike
Jul 21 '06 #4

P: n/a
Thank you! Right now I'm 2 for 2 - use Excel for charting! That was a
pretty slick scatter graph! Send me the code! :o)

Mike
DFS wrote:
Takeadoe wrote:
I'm doubtful that the group is unbiased, but I will ask anyhow :o).
If one intends to plot lots of data, primarily XY line and scatter
plots, and mass produce them (in many cases I will be doing 88 graphs
at a time - 1 for each of 88 counties), will Exel be the best bet, or
is Access equally capable? I might mention that in time, I will be
moving all of my data into Access databases. I'm slowing learning
charting and automation in Excel, and I'd hate to spend much more
time here if it is going to be easier to work in Access. Any and all
comments/thoughts are welcome and appreciated.

First, you'll find nobody here cares about scatter charts. (ha! That's an
"inside joke" on cdma because I recently posted about doing scatter charts
in Access, and nobody answered until I got persistent on their @ss).

Anyway, it seems few here have any Access scatter chart experience, and
nobody was able to show me a reasonably attractive scatter chart drawn in
Access. But check out this one a colleague did in Excel
http://www.angelfire.com/planet/dfs0...er_example.PNG

I think you'll be better off with Excel charting, especially for scatter
charts. I don't know all the Excel scatter chart options, but I'm sure you
can put the data labels on it, axis labels, etc. If you later end up with
your data in Access, you can still query it from Excel and pull it into
Excel for charting.
Jul 21 '06 #5

P: n/a
In my experience, Excel is much faster at creating the charts than
Access.

What I've done in the past is to store all the data in Access, then use
Excel to link/query the data, and create the charts. You might want to
look at creating 'dashboards' for Excel.
Takeadoe wrote:
I'm doubtful that the group is unbiased, but I will ask anyhow :o). If
one intends to plot lots of data, primarily XY line and scatter plots,
and mass produce them (in many cases I will be doing 88 graphs at a
time - 1 for each of 88 counties), will Exel be the best bet, or is
Access equally capable? I might mention that in time, I will be moving
all of my data into Access databases. I'm slowing learning charting
and automation in Excel, and I'd hate to spend much more time here if
it is going to be easier to work in Access. Any and all
comments/thoughts are welcome and appreciated.

Regards,
Mike
Jul 21 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.