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
5  2371 
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.
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
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
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.
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: lawrence |
last post by:
2 Questions:
1.) Can anyone think of a way to speed up this function? It is
terribly slow. I plan to reduce the number of directories to 3, which
I guess will speed it up in the end.
2.) This seems to be the brute force method, and I'm wondering if
anyone can think of a better strategy. I've been asked to make life
easy on graphic designers by not making assumptions about where I
might find the files that the software might need to...
|
by: Peter |
last post by:
I really can't understand why you still use it or why you started using it
in the first place.
|
by: Kamus of Kadizhar |
last post by:
I have the following function which generates MD5 hashes for files on a
local and remote server. The remote server has a little applet that
runs from inetd and generates an MD5 hash given the file name.
The problem is that it takes 2+ minutes to generate the MD5 hash, so
this function takes about 5 minutes every time it is called. Since the
first MD5 hash is generated on a remote machine, the local machine does
nothing but wait for...
|
by: Barney Norris |
last post by:
Hi,
The W3C validator tells me this page isn't valid HTML 4.01 Strict:
http://www-student.cs.york.ac.uk/~jban100/wont_validate.html
The reason it gives is I've closed meta tags with a '/'
("character data is not allowed here")
e.g.
|
by: Lucky Carl |
last post by:
DFS wrote:
> You wiped XP but you're still obsessed with Windows. You need to wipe
> your brain.
Why does Microsoft pay this person to astroturf in COLA ?
| | |
by: Montrose... |
last post by:
After working in c# for a year, the only conclusion I can come to is
that I wish I knew c.
All I need is Linux, the gnu c compiler and I can do anything.
Web services are just open sockets hooked up to interfaces.
The Gtk is more than enough gui.
|
by: cooch17 |
last post by:
Greetings -
I have a number of websites that make use of popups spawned by a user
clicking a link. Nothing fancy - here is typical code:
<a href="popup.html" target="pop_win"
onClick="msgWindow=window.open('','pop_win',
'resizable=no,width=600,height=300')"> click here</a>
|
by: comp.lang.php |
last post by:
I have a counter that evokes the "Three Strikes You're Out" rule.. if
you make more than N mistakes it auto-resets to avoid flooding
$_SESSION with attempt after attempt, etc.
However, the counter never advances beyond 1!
// HANDLE THE PART WHERE THE STUDENT INFORMATION WILL BE UPDATED OR
SEARCHED
if (is_array($_POST) && @sizeof($_POST) > 0) {
|
by: sloan |
last post by:
This is just a in-general question.
As 2.0 has launched, and you guys are developing apps in 2.0 .. What are
you doing about your namespace'ing ?
Before 2.0 , my namespaces went something like this
GranadaCoder.*
(I put all framework pieces there, like GranadaCoder.Data ,
GranadaCoder.Drawing , GranadaCoder.Exceptions , GranadaCoder.UIFramework ,
|
by: BoogieWithStu22 |
last post by:
I am running into a problem with a web page I have created when
viewing it in IE6 on some machines. The page has a database lookup.
The user enters an account name or number and clicks a lookup button.
This hits an AS400 database looks for matches and returns a dataset
that is used to populate a datagrid. The user then selects one of the
entries from the list, this entry is used to populate a couple of
textboxes on the page and a couple...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
