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

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.

Takeadoe <mtonkovich@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

Takeadoe wrote:>
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.

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